Re: Upgrade problem

On Thu, Feb 16, 2012 at 3:49 AM, Linda Ursin <..hidden..> wrote:

heksebua=# \dt

Ok, in this database:

\dt defaults

\dt users

\dt users_conf

Then:

select * from defaults where setting_key = 'version';

public | partscustomer | table | ledgersmb
public | partsgroup | table | ledgersmb

public | partstax | table | ledgersmb
public | partsvendor | table | ledgersmb

public | pricegroup | table | ledgersmb
public | project | table | ledgersmb
public | recurring | table | ledgersmb
public | recurringemail | table | ledgersmb

public | recurringprint | table | ledgersmb
public | shipto | table | ledgersmb
public | sic | table | ledgersmb
public | status | table | ledgersmb

public | tax | table | ledgersmb
public | taxcategory | table | ledgersmb
public | taxmodule | table | ledgersmb
public | transactions | table | ledgersmb

public | translation | table | ledgersmb
public | vendor | table | ledgersmb
public | vendortax | table | ledgersmb
public | warehouse | table | ledgersmb

public | yearend | table | ledgersmb
(47 rows)

heksebua=# \dn
List of schemas
Name | Owner
--------------------+----------

information_schema | postgres
lsmb_13fail | postgres
pg_catalog | postgres
pg_toast | postgres
pg_toast_temp_1 | postgres

public | postgres

(6 rows)

~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~

Linda Ursin
Heksebua

Adresse: Tlf: (+47) 402 40 767
Solvang www: http://heksebua.com
7288 Soknedal E-post: ..hidden..

Org: NO 995 578 107

On Thu, Feb 16, 2012 at 12:45 PM, Chris Travers <..hidden..> wrote:

On Thu, Feb 16, 2012 at 3:38 AM, Linda Ursin <..hidden..> wrote:

postgres=# \dn
List of schemas
Name | Owner
--------------------+----------
information_schema | postgres
pg_catalog | postgres

pg_toast | postgres
pg_toast_temp_1 | postgres
public | postgres
(5 rows)

Try connecting to your ledgersmb database and repeat the \dt and the \dn tests.

you can do this with psql -U postgres dbname or once in psql \c dbname
(substitute dbname with your database name)

If unsure psql -U postgres -l

------------------------------------------------------------------------------
Virtualization & Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users

------------------------------------------------------------------------------
Virtualization & Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users