Warehouses->reports->Transfers gives this error? DBD::Pg::st execute failed: ERROR: permission denied for relation trf Error!
SELECT trf.id, trf.transdate, trf.trfnumber, trf.description, trf.notes, trf.department_id, d.description AS department, trf.from_warehouse_id, w1.description AS from_warehouse, trf.to_warehouse_id, w2.description AS to_warehouse FROM trf JOIN department d ON (d.id = trf.department_id) JOIN warehouse w1 ON (w1.id = trf.from_warehouse_id) JOIN warehouse w2 ON (w2.id = trf.to_warehouse_id) WHERE (1 = 1) ORDER BY transdate ASC ERROR: permission denied for relation trf On Dec 27, 2010, at 2:50 PM, Rolf Stöckli wrote: > Am 27.12.2010 21:41, schrieb [email protected]: >> postg...@obcpd:/usr/local/sql-ledger$ psql -U postgres data-set-test-123 < >> sql/Pg-custom_tables.sql >> ERROR: relation "trf" already exists > > When you create a new dataset, Pg-custom_tables.sql runs automatically. > You only need it for datasets that you transfer from "unenhanced" > SQL-Ledger. > > R. > _______________________________________________ > SQL-Ledger mailing list > [email protected] > http://lists.ledger123.com/mailman/listinfo/sql-ledger
_______________________________________________ SQL-Ledger mailing list [email protected] http://lists.ledger123.com/mailman/listinfo/sql-ledger
