Re: Teething problem after upgrade from sql-ledger

["Chris Travers" <..hidden..>]

Sorry about the delay.  I have some answers for you.

1)  The problem is caused by loading the database as a database superuser.  You could do something like:
\dt
(lists 100 or so tables)
ALTER TABLE ar OWNER TO ledgersmb;
....

2)  You could also do a simple dump of the database, drop it, create the language, and run psql as the desired user to restore:
pg_dump -O -d lsmb_dbname -U postgres > lsmb.dump
# Note the -O flag which tells pg_dump to ignore ownership information.
dropdb -U postgres lsmb_dbname
createdb -U postgres lsmb_dbname
createlang -U postgres -d lsmb_dbname plpgsql
psql -U lsmb_user -d lsmb_dbname < lsmb.dump


That will change all the db object ownership information.

Best Wishes,
Chris Travers