Re: [Ledger-smb-users] DELETE error

2012-04-10 Thread billy akazawa
Thanks, Erik, > Error!* >> *DELETE FROM gl WHERE id = '1'* >> * >> ERROR: permission denied for relation yearend* >> *CONTEXT: SQL statement "delete from yearend where trans_id = old.id"* >> PL/pgSQL function "del_yearend" line 3 at SQL statement* >> > > To solve that you need to ru: > > GRANT del

Re: [Ledger-smb-users] DELETE error

2012-04-09 Thread Michael Richardson
I would prefer to support deleting/editing transactions which have not yet been reconciled. -- ] He who is tired of Weird Al is tired of life! | firewalls [ ] Michael Richardson, Sandelman Software Works, Ottawa, ON|net architect[ ] m...@sandelman.ottawa.on.ca http://www.

Re: [Ledger-smb-users] DELETE error

2012-04-09 Thread Erik Huelsmann
On Mon, Apr 9, 2012 at 9:29 AM, billy akazawa wrote: > Thanks, Erik, > >> Well the short term solution would be to use psql to log into your >> database and issue >> >> GRANT delete ON gl TO ; >> >> OK. I did that and now get the following: > > Error!* > *DELETE FROM gl WHERE id = '1'* > * > ERRO

Re: [Ledger-smb-users] DELETE error

2012-04-09 Thread billy akazawa
Thanks, Erik, > Well the short term solution would be to use psql to log into your > database and issue > > GRANT delete ON gl TO ; > > OK. I did that and now get the following: Error!* *DELETE FROM gl WHERE id = '1'* *ERROR: permission denied for relation yearend* *CONTEXT: SQL statement "delete

Re: [Ledger-smb-users] DELETE error

2012-04-08 Thread Erik Huelsmann
On Sun, Apr 8, 2012 at 10:50 PM, billy akazawa wrote: I'm using 1.3 and would really like to be able to delete the transactions. > > I file a corporate return and my tax accountant works off the paper ledger > printout underscored by the copies of the paper double-entry invoices I > furnish so

Re: [Ledger-smb-users] DELETE error

2012-04-08 Thread billy akazawa
> > Hope that helps! > > Bye, > > > Erik. > Thanks, Erik > I'm using 1.3 and would really like to be able to delete the transactions. I file a corporate return and my tax accountant works off the paper ledger printout underscored by the copies of the paper double-entry invoices I furnish so the au

Re: [Ledger-smb-users] DELETE error

2012-04-08 Thread Erik Huelsmann
Hi Billy, On Sun, Apr 8, 2012 at 5:31 AM, billy akazawa wrote: > Hi, > I'm trying to delete transactions from the Edit General Ledger Transaction > screen, but keep getting the following error: > > Error!* > *DELETE FROM gl WHERE id = '1'* > ERROR: permission denied for relation gl* > > I tried

[Ledger-smb-users] DELETE error

2012-04-07 Thread billy akazawa
Hi, I'm trying to delete transactions from the Edit General Ledger Transaction screen, but keep getting the following error: Error!* *DELETE FROM gl WHERE id = '1'* ERROR: permission denied for relation gl* I tried going to Admin Users > Search Users and making sure all the permissions boxes were