koumbit-ls=# \i Pg-upgrade-2.6.18-2.6.19.sql
BEGIN
psql:Pg-upgrade-2.6.18-2.6.19.sql:3: NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "ap_pkey" for table "ap"
ALTER TABLE
psql:Pg-upgrade-2.6.18-2.6.19.sql:5: NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "ar_pkey" for table "ar"
ALTER TABLE
psql:Pg-upgrade-2.6.18-2.6.19.sql:7: NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "assembly_pkey" for table "assembly"
ALTER TABLE
psql:Pg-upgrade-2.6.18-2.6.19.sql:9: NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "business_pkey" for table "business"
ALTER TABLE
psql:Pg-upgrade-2.6.18-2.6.19.sql:11: NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "customer_pkey" for table "customer"
ALTER TABLE
psql:Pg-upgrade-2.6.18-2.6.19.sql:13: NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "customertax_pkey" for table "customertax"
ALTER TABLE
psql:Pg-upgrade-2.6.18-2.6.19.sql:15: NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "department_pkey" for table "department"
ALTER TABLE
psql:Pg-upgrade-2.6.18-2.6.19.sql:17: NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "dpt_trans_pkey" for
table "dpt_trans"
ALTER TABLE
psql:Pg-upgrade-2.6.18-2.6.19.sql:19: NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "employee_pkey" for table "employee"
ALTER TABLE
psql:Pg-upgrade-2.6.18-2.6.19.sql:21: NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "exchangerate_pkey" for table "exchangerate"
ALTER TABLE
psql:Pg-upgrade-2.6.18-2.6.19.sql:23: NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "gifi_pkey" for table "gifi"
ALTER TABLE
psql:Pg-upgrade-2.6.18-2.6.19.sql:25: NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "gl_pkey" for table "gl"
ALTER TABLE
psql:Pg-upgrade-2.6.18-2.6.19.sql:27: NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "invoice_pkey" for table "invoice"
ALTER TABLE
psql:Pg-upgrade-2.6.18-2.6.19.sql:29: NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "jcitems_pkey" for table "jcitems"
ALTER TABLE
psql:Pg-upgrade-2.6.18-2.6.19.sql:31: NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "language_pkey" for table "language"
ALTER TABLE
psql:Pg-upgrade-2.6.18-2.6.19.sql:33: NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "makemodel_pkey" for
table "makemodel"
ALTER TABLE
psql:Pg-upgrade-2.6.18-2.6.19.sql:35: NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "oe_pkey" for table "oe"
ALTER TABLE
setval
--------
1
(1 row)
UPDATE 592
psql:Pg-upgrade-2.6.18-2.6.19.sql:40: NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "orderitems_pkey" for table "orderitems"
ALTER TABLE
psql:Pg-upgrade-2.6.18-2.6.19.sql:42: NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "parts_pkey" for table "parts"
ALTER TABLE
psql:Pg-upgrade-2.6.18-2.6.19.sql:44: NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "partsgroup_pkey" for table "partsgroup"
ALTER TABLE
psql:Pg-upgrade-2.6.18-2.6.19.sql:46: NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "partstax_pkey" for table "partstax"
ALTER TABLE
ALTER TABLE
ALTER TABLE
psql:Pg-upgrade-2.6.18-2.6.19.sql:50: NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "pricegroup_pkey" for table "pricegroup"
ALTER TABLE
psql:Pg-upgrade-2.6.18-2.6.19.sql:52: NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "project_pkey" for table "project"
ALTER TABLE
psql:Pg-upgrade-2.6.18-2.6.19.sql:54: NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "recurringemail_pkey" for table "recurringemail"
psql:Pg-upgrade-2.6.18-2.6.19.sql:54: ERROR: could not create unique index
DETAIL: Table contains duplicated values.
psql:Pg-upgrade-2.6.18-2.6.19.sql:56: ERROR: current transaction is aborted, commands ignored until end of transaction blockpsql:Pg-upgrade-2.6.18-2.6.19.sql:58: ERROR: current transaction is aborted, commands ignored until end of transaction blockpsql:Pg-upgrade-2.6.18-2.6.19.sql:60: ERROR: current transaction is aborted, commands ignored until end of transaction blockpsql:Pg-upgrade-2.6.18-2.6.19.sql:62: ERROR: current transaction is aborted, commands ignored until end of transaction blockpsql:Pg-upgrade-2.6.18-2.6.19.sql:71: ERROR: current transaction is aborted, commands ignored until end of transaction blockpsql:Pg-upgrade-2.6.18-2.6.19.sql:73: ERROR: current transaction is aborted, commands ignored until end of transaction blockpsql:Pg-upgrade-2.6.18-2.6.19.sql:75: ERROR: current transaction is aborted, commands ignored until end of transaction blockpsql:Pg-upgrade-2.6.18-2.6.19.sql:77: ERROR: current transaction is aborted, commands ignored until end of transaction blockpsql:Pg-upgrade-2.6.18-2.6.19.sql:79: ERROR: current transaction is aborted, commands ignored until end of transaction blockpsql:Pg-upgrade-2.6.18-2.6.19.sql:81: ERROR: current transaction is aborted, commands ignored until end of transaction blockpsql:Pg-upgrade-2.6.18-2.6.19.sql:82: ERROR: current transaction is aborted, commands ignored until end of transaction blockpsql:Pg-upgrade-2.6.18-2.6.19.sql:83: ERROR: current transaction is aborted, commands ignored until end of transaction blockpsql:Pg-upgrade-2.6.18-2.6.19.sql:86: ERROR: current transaction is aborted, commands ignored until end of transaction blockpsql:Pg-upgrade-2.6.18-2.6.19.sql:88: ERROR: current transaction is aborted, commands ignored until end of transaction blockpsql:Pg-upgrade-2.6.18-2.6.19.sql:89: ERROR: current transaction is aborted, commands ignored until end of transaction blockpsql:Pg-upgrade-2.6.18-2.6.19.sql:91: ERROR: current transaction is aborted, commands ignored until end of transaction blockpsql:Pg-upgrade-2.6.18-2.6.19.sql:92: ERROR: current transaction is aborted, commands ignored until end of transaction blockpsql:Pg-upgrade-2.6.18-2.6.19.sql:93: ERROR: current transaction is aborted, commands ignored until end of transaction blockpsql:Pg-upgrade-2.6.18-2.6.19.sql:96: ERROR: current transaction is aborted, commands ignored until end of transaction blockpsql:Pg-upgrade-2.6.18-2.6.19.sql:98: ERROR: current transaction is aborted, commands ignored until end of transaction blockpsql:Pg-upgrade-2.6.18-2.6.19.sql:99: ERROR: current transaction is aborted, commands ignored until end of transaction blockpsql:Pg-upgrade-2.6.18-2.6.19.sql:101: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:Pg-upgrade-2.6.18-2.6.19.sql:102: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:Pg-upgrade-2.6.18-2.6.19.sql:103: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:Pg-upgrade-2.6.18-2.6.19.sql:106: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:Pg-upgrade-2.6.18-2.6.19.sql:108: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:Pg-upgrade-2.6.18-2.6.19.sql:109: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:Pg-upgrade-2.6.18-2.6.19.sql:111: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:Pg-upgrade-2.6.18-2.6.19.sql:112: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:Pg-upgrade-2.6.18-2.6.19.sql:113: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:Pg-upgrade-2.6.18-2.6.19.sql:116: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:Pg-upgrade-2.6.18-2.6.19.sql:118: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:Pg-upgrade-2.6.18-2.6.19.sql:119: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:Pg-upgrade-2.6.18-2.6.19.sql:121: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:Pg-upgrade-2.6.18-2.6.19.sql:122: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:Pg-upgrade-2.6.18-2.6.19.sql:123: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:Pg-upgrade-2.6.18-2.6.19.sql:126: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:Pg-upgrade-2.6.18-2.6.19.sql:128: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:Pg-upgrade-2.6.18-2.6.19.sql:129: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:Pg-upgrade-2.6.18-2.6.19.sql:134: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:Pg-upgrade-2.6.18-2.6.19.sql:140: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:Pg-upgrade-2.6.18-2.6.19.sql:146: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:Pg-upgrade-2.6.18-2.6.19.sql:148: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:Pg-upgrade-2.6.18-2.6.19.sql:150: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:Pg-upgrade-2.6.18-2.6.19.sql:151: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:Pg-upgrade-2.6.18-2.6.19.sql:152: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:Pg-upgrade-2.6.18-2.6.19.sql:153: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:Pg-upgrade-2.6.18-2.6.19.sql:155: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:Pg-upgrade-2.6.18-2.6.19.sql:156: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:Pg-upgrade-2.6.18-2.6.19.sql:157: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:Pg-upgrade-2.6.18-2.6.19.sql:159: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:Pg-upgrade-2.6.18-2.6.19.sql:164: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:Pg-upgrade-2.6.18-2.6.19.sql:166: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:Pg-upgrade-2.6.18-2.6.19.sql:224: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:Pg-upgrade-2.6.18-2.6.19.sql:226: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:Pg-upgrade-2.6.18-2.6.19.sql:283: ERROR: current transaction is aborted, commands ignored until end of transaction block
psql:Pg-upgrade-2.6.18-2.6.19.sql:307: ERROR: current transaction is aborted, commands ignored until end of transaction block
ROLLBACK