Hi,
I was running the official sql-ledger, now I wanted to try the enhanced
version, moved the official code from /sql-ledger to tmp dir, downloaded the
enhanced .tar from git and untar-ed it into /sql-ledger. Added new data set and
wanted to import the enhanced version tables, I got these errors?
postg...@obcpd:/usr/local/sql-ledger$ psql -U postgres data-set-test-123 <
sql/Pg-custom_tables.sql
ERROR: relation "trf" already exists
ERROR: column "department_id" of relation "inventory" already exists
ERROR: column "delivereddate" of relation "trf" already exists
ERROR: column "transdate" of relation "invoice" already exists
ERROR: relation "fifo" already exists
ERROR: column "lastcost" of relation "invoice" already exists
ERROR: relation "invoicetax" already exists
ERROR: relation "invoice_parts_id" already exists
ERROR: relation "fifo_parts_id" already exists
ERROR: relation "build" already exists
ERROR: column "description" of relation "inventory" already exists
ERROR: column "warehouse_id" of relation "fifo" already exists
ERROR: column "warehouse_id" of relation "invoice" already exists
ERROR: column "invoice_id" of relation "fifo" already exists
ERROR: column "invoice_id" of relation "inventory" already exists
ERROR: relation "inventory_invoice_id" already exists
ERROR: column "cogs" of relation "invoice" already exists
ERROR: column "cogs" of relation "inventory" already exists
ERROR: relation "entry_id" already exists
nextval
---------
2
(1 row)
ERROR: column "entry_id" of relation "acc_trans" already exists
UPDATE 0
UPDATE 0
ERROR: relation "fifo_trans_id" already exists
ERROR: relation "invoice_qty" already exists
ERROR: relation "customerloginid" already exists
nextval
---------
2
(1 row)
ERROR: relation "customercart" already exists
ERROR: relation "customerlogin" already exists
ERROR: relation "partsattr" already exists
postg...@obcpd:/usr/local/sql-ledger$ psql -U postgres data-set-demo <
sql/Pg-custom_tables.sql
ERROR: relation "trf" already exists
ERROR: column "department_id" of relation "inventory" already exists
ERROR: column "delivereddate" of relation "trf" already exists
ERROR: column "transdate" of relation "invoice" already exists
ERROR: relation "fifo" already exists
ERROR: column "lastcost" of relation "invoice" already exists
ERROR: relation "invoicetax" already exists
ERROR: relation "invoice_parts_id" already exists
ERROR: relation "fifo_parts_id" already exists
ERROR: relation "build" already exists
ERROR: column "description" of relation "inventory" already exists
ERROR: column "warehouse_id" of relation "fifo" already exists
ERROR: column "warehouse_id" of relation "invoice" already exists
ERROR: column "invoice_id" of relation "fifo" already exists
ERROR: column "invoice_id" of relation "inventory" already exists
ERROR: relation "inventory_invoice_id" already exists
ERROR: column "cogs" of relation "invoice" already exists
ERROR: column "cogs" of relation "inventory" already exists
ERROR: relation "entry_id" already exists
nextval
---------
2
(1 row)
ERROR: column "entry_id" of relation "acc_trans" already exists
UPDATE 0
UPDATE 0
ERROR: relation "fifo_trans_id" already exists
ERROR: relation "invoice_qty" already exists
ERROR: relation "customerloginid" already exists
nextval
---------
2
(1 row)
ERROR: relation "customercart" already exists
ERROR: relation "customerlogin" already exists
ERROR: relation "partsattr" already exists
Thanks,
Jamal
_______________________________________________
SQL-Ledger mailing list
[email protected]
http://lists.ledger123.com/mailman/listinfo/sql-ledger
