> DBD::Pg::st execute failed: ERROR: permission denied for relation trf > Error! >
The Postgresql owner of table trf must be the same as for all the other tables. Hope this helps, Bernd 2010年 12月 29日（水）12:01 am に [email protected] さんは書きました： > 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?kli 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 > > -- ファースト・チョイス・インターネット(有) First Choice Internet Ltd., Tokyo Tel. 03-6379-2516 Fax. 03-6379-2516 mail: [email protected] url: http://www.choicenet.ne.jp _______________________________________________ SQL-Ledger mailing list [email protected] http://lists.ledger123.com/mailman/listinfo/sql-ledger
