On 6/16/07, Chris Travers <[EMAIL PROTECTED]> wrote:
On 6/15/07, Robert Fraser <[EMAIL PROTECTED]> wrote:
> Hi
>
> I am getting 2 of these (vendor and customer) when I try to manually
upgrade
> from Sql-ledger 2.6.5 to Ledgersmb 1.1.12 :
>
> psql:/usr/local/lib/egsql-ledger/sql/Pg-upgrade-2.6.17-2.6.18.sql:211:
> ERROR: duplicate key violates unique constraint "transactions_pkey"
>
Try running the Pg-upgrade scripts manually and see where they fail.
This can be done in psql or Pgadmin III.
Thanks Chris
It is failing at line 139 and line 211 of
/usr/local/lib/egsql-ledger/sql/Pg-upgrade-2.6.17-2.6.18.sql
INSERT INTO transactions (id, table_name) SELECT id, 'customer' FROM
customer;
and
INSERT INTO transactions (id, table_name) SELECT id, 'vendor' FROM vendor;
There seem to be about 10 duplicate ids from customer and 5 from vendor
Best regards
Rob
Cheers
Rob
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
