On Wed, Oct 10, 2012 at 8:33 PM, Penguin Products <[email protected]> wrote: > > Hi Armaghan > > We ran the Pg-custom_tables.sql on the database after importing the > dataset. no errors were reported during that process, but we still have the > same error on login into sql-ledger > > Error! > > SELECT * FROM defaults > ERROR: permission denied for relation defaults > > If I login using a test database Sql-ledger runs fine.
This error is due to incorrect ownership of tables. The database username you are using in connection information (through admin.pl) does not have access to all the tables. A simple way is to change the owner of the table to the user name you have used in admin.pl. Here is how to do it in psql: \d # Display all tables alter table defaults owner to sql-ledger; # Change the ownership of defaults table to sql-ledger. It will probably easier to do it with phppgadmin Let me know your problem is still unresolved. Regards _______________________________________________ SQL-Ledger mailing list [email protected] http://lists.ledger123.com/mailman/listinfo/sql-ledger
