[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Error deleting warehouse



Hi Brian,Â

On Tue, Feb 5, 2013 at 12:36 AM, Brian Wolf <..hidden..> wrote:
Our client is getting an error when attempting to delete a warehouse.
The error message:
 DELETE FROM warehouse
 WHERE id = ?
 ERROR: permission denied for relation warehouse

Strangely, there is are checkboxes on the System - Admin User screen for creating and editing warehouses, but none for deleting warehouses.

That's the way SQL Ledger edits database items: delete them and then re-insert. In our new code, we use UPDATE instead.

So, the user probably was editing a warehouse.


HTH,

Erik.
------------------------------------------------------------------------------
Free Next-Gen Firewall Hardware Offer
Buy your Sophos next-gen firewall before the end March 2013 
and get the hardware for free! Learn more.
http://p.sf.net/sfu/sophos-d2d-feb
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users