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

Re: Error deleting warehouse



Display a list of warehouses; select one of them and display it; click Delete button.  What other way is there to delete it?

Thanks.
Brian

Brian Wolf
Phone: 410.367.2958
Email: ..hidden..
Try out Activus Secure Payments™, our recurring payments application.
On 02/05/2013 01:49 AM, Erik Huelsmann wrote:
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

------------------------------------------------------------------------------
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