On 23/05/10 07:43, Mike Mylonas wrote:
Howdy all,

Ok, I think that I am going officially crazy, cause I can't see to get
my head around this issue.

When trying to post an invoice I am getting the following error message
(it is asking me to download is.PL)

DBD::Pg::db do failed: ERROR:  permission denied for sequence entry_id
at SL/IS.pm line 1127.

I have checked and the Pg-custom_tables.sql changes have been included.
You have created the sequence through a different user than the one who has access to your sql-ledger tables. ('postgres' instead of 'sql-ledger')

Find out which one is the correct postgres user configured for your SL users and change the ownership of entry_id sequence according using psql:

alter sequence entry_id owner to sql-ledger;

Regards
Armaghan
_______________________________________________
SQL-Ledger mailing list
[email protected]
http://lists.ledger123.com/mailman/listinfo/sql-ledger

Reply via email to