I get lots of errors when i try to restore my database for sql-ledger to the shiny new smbledger I have attached them hope this list allows attachment. the dump goes fine but the restore seem very bad here are the versions involed
old server
sql-ledger-2.6.25
postgresql-server-7.4.13_1
new server
ledgersmb 1.2.3
postgresql-server-8.2.3
D:\Program Files\pgAdmin III\1.6\pg_dump.exe -i -h computerking.ca -p 5432 -U pgsql -F c -b -v -f "smb1" computerking pg_dump: reading schemas pg_dump: reading user-defined functions pg_dump: reading user-defined types pg_dump: reading procedural languages pg_dump: reading user-defined aggregate functions pg_dump: reading user-defined operators pg_dump: reading user-defined operator classes pg_dump: reading user-defined operator families pg_dump: reading user-defined conversions pg_dump: reading user-defined tables pg_dump: reading table inheritance information pg_dump: reading rewrite rules pg_dump: reading type casts pg_dump: finding inheritance relationships pg_dump: reading column info for interesting tables pg_dump: finding the columns and types of table "makemodel" pg_dump: finding the columns and types of table "gl" pg_dump: finding default expressions of table "gl" pg_dump: finding the columns and types of table "chart" pg_dump: finding default expressions of table "chart" pg_dump: finding the columns and types of table "gifi" pg_dump: finding the columns and types of table "defaults" pg_dump: finding default expressions of table "defaults" pg_dump: finding the columns and types of table "acc_trans" pg_dump: finding default expressions of table "acc_trans" pg_dump: finding the columns and types of table "invoice" pg_dump: finding default expressions of table "invoice" pg_dump: finding the columns and types of table "customer" pg_dump: finding default expressions of table "customer" pg_dump: finding the columns and types of table "parts" pg_dump: finding default expressions of table "parts" pg_dump: finding the columns and types of table "assembly" pg_dump: finding the columns and types of table "ar" pg_dump: finding default expressions of table "ar" pg_dump: finding the columns and types of table "ap" pg_dump: finding default expressions of table "ap" pg_dump: finding the columns and types of table "partstax" pg_dump: finding the columns and types of table "tax" pg_dump: finding the columns and types of table "customertax" pg_dump: finding the columns and types of table "vendortax" pg_dump: finding the columns and types of table "oe" pg_dump: finding default expressions of table "oe" pg_dump: finding the columns and types of table "orderitems" pg_dump: finding default expressions of table "orderitems" pg_dump: finding the columns and types of table "exchangerate" pg_dump: finding the columns and types of table "employee" pg_dump: finding default expressions of table "employee" pg_dump: finding the columns and types of table "shipto" pg_dump: finding the columns and types of table "vendor" pg_dump: finding default expressions of table "vendor" pg_dump: finding the columns and types of table "project" pg_dump: finding default expressions of table "project" pg_dump: finding the columns and types of table "partsgroup" pg_dump: finding default expressions of table "partsgroup" pg_dump: finding the columns and types of table "status" pg_dump: finding default expressions of table "status" pg_dump: finding the columns and types of table "department" pg_dump: finding default expressions of table "department" pg_dump: finding the columns and types of table "dpt_trans" pg_dump: finding the columns and types of table "business" pg_dump: finding default expressions of table "business" pg_dump: finding the columns and types of table "sic" pg_dump: finding the columns and types of table "warehouse" pg_dump: finding default expressions of table "warehouse" pg_dump: finding the columns and types of table "inventory" pg_dump: finding the columns and types of table "yearend" pg_dump: finding the columns and types of table "partsvendor" pg_dump: finding the columns and types of table "pricegroup" pg_dump: finding default expressions of table "pricegroup" pg_dump: finding the columns and types of table "partscustomer" pg_dump: finding the columns and types of table "language" pg_dump: finding the columns and types of table "audittrail" pg_dump: finding default expressions of table "audittrail" pg_dump: finding the columns and types of table "translation" pg_dump: finding the columns and types of table "recurring" pg_dump: finding default expressions of table "recurring" pg_dump: finding the columns and types of table "recurringemail" pg_dump: finding the columns and types of table "recurringprint" pg_dump: finding the columns and types of table "jcitems" pg_dump: finding default expressions of table "jcitems" pg_dump: flagging inherited columns in subtables pg_dump: reading indexes pg_dump: reading indexes for table "makemodel" pg_dump: reading indexes for table "gl" pg_dump: reading indexes for table "chart" pg_dump: reading indexes for table "gifi" pg_dump: reading indexes for table "acc_trans" pg_dump: reading indexes for table "invoice" pg_dump: reading indexes for table "customer" pg_dump: reading indexes for table "parts" pg_dump: reading indexes for table "assembly" pg_dump: reading indexes for table "ar" pg_dump: reading indexes for table "ap" pg_dump: reading indexes for table "partstax" pg_dump: reading indexes for table "customertax" pg_dump: reading indexes for table "vendortax" pg_dump: reading indexes for table "oe" pg_dump: reading indexes for table "orderitems" pg_dump: reading indexes for table "exchangerate" pg_dump: reading indexes for table "employee" pg_dump: reading indexes for table "shipto" pg_dump: reading indexes for table "vendor" pg_dump: reading indexes for table "project" pg_dump: reading indexes for table "partsgroup" pg_dump: reading indexes for table "status" pg_dump: reading indexes for table "department" pg_dump: reading indexes for table "partsvendor" pg_dump: reading indexes for table "pricegroup" pg_dump: reading indexes for table "language" pg_dump: reading indexes for table "audittrail" pg_dump: reading indexes for table "translation" pg_dump: reading indexes for table "jcitems" pg_dump: reading constraints pg_dump: reading foreign key constraints for table "gl" pg_dump: reading foreign key constraints for table "customer" pg_dump: reading foreign key constraints for table "ar" pg_dump: reading foreign key constraints for table "ap" pg_dump: reading foreign key constraints for table "oe" pg_dump: reading foreign key constraints for table "vendor" pg_dump: reading triggers pg_dump: reading triggers for table "gl" pg_dump: reading triggers for table "customer" pg_dump: reading triggers for table "ar" pg_dump: reading triggers for table "ap" pg_dump: reading triggers for table "oe" pg_dump: reading triggers for table "vendor" pg_dump: reading dependency data pg_dump: saving encoding = SQL_ASCII pg_dump: saving standard_conforming_strings = off pg_dump: saving database definition pg_dump: dumping contents of table acc_trans pg_dump: dumping contents of table ap pg_dump: dumping contents of table ar pg_dump: dumping contents of table assembly pg_dump: dumping contents of table audittrail pg_dump: dumping contents of table business pg_dump: dumping contents of table chart pg_dump: dumping contents of table customer pg_dump: dumping contents of table customertax pg_dump: dumping contents of table defaults pg_dump: dumping contents of table department pg_dump: dumping contents of table dpt_trans pg_dump: dumping contents of table employee pg_dump: dumping contents of table exchangerate pg_dump: dumping contents of table gifi pg_dump: dumping contents of table gl pg_dump: dumping contents of table inventory pg_dump: dumping contents of table invoice pg_dump: dumping contents of table jcitems pg_dump: dumping contents of table language pg_dump: dumping contents of table makemodel pg_dump: dumping contents of table oe pg_dump: dumping contents of table orderitems pg_dump: dumping contents of table parts pg_dump: dumping contents of table partscustomer pg_dump: dumping contents of table partsgroup pg_dump: dumping contents of table partstax pg_dump: dumping contents of table partsvendor pg_dump: dumping contents of table pricegroup pg_dump: dumping contents of table project pg_dump: dumping contents of table recurring pg_dump: dumping contents of table recurringemail pg_dump: dumping contents of table recurringprint pg_dump: dumping contents of table shipto pg_dump: dumping contents of table sic pg_dump: dumping contents of table status pg_dump: dumping contents of table tax pg_dump: dumping contents of table translation pg_dump: dumping contents of table vendor pg_dump: dumping contents of table vendortax pg_dump: dumping contents of table warehouse pg_dump: dumping contents of table yearend Process returned exit code 0.