Deleted the old data-set and created new one and that seems to work, no errors. Thanks,
On Dec 28, 2010, at 9:01 AM, [email protected] wrote: > 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
