Hi Brian,
On Tue, Feb 5, 2013 at 12:36 AM, Brian Wolf <br...@activustech.com> 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
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
