All pastes #2116643 Raw Edit

Upgrading data from 1.6.04 to 2.

public text v1 · immutable
#2116643 ·published 2012-02-10 17:07 UTC
rendered paste body
$ psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql evergreen
CREATE SCHEMA
BEGIN
ALTER TABLE
ALTER TABLE
CREATE FUNCTION
CREATE FUNCTION
 change_db_setting 
-------------------
 
(1 row)

CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
ALTER TABLE
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:269: NOTICE:  CREATE TABLE will create implicit sequence "circ_matrix_weights_id_seq" for serial column "circ_matrix_weights.id"
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:269: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "circ_matrix_weights_pkey" for table "circ_matrix_weights"
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:269: NOTICE:  CREATE TABLE / UNIQUE will create implicit index "circ_matrix_weights_name_key" for table "circ_matrix_weights"
CREATE TABLE
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:287: NOTICE:  CREATE TABLE will create implicit sequence "hold_matrix_weights_id_seq" for serial column "hold_matrix_weights.id"
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:287: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "hold_matrix_weights_pkey" for table "hold_matrix_weights"
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:287: NOTICE:  CREATE TABLE / UNIQUE will create implicit index "hold_matrix_weights_name_key" for table "hold_matrix_weights"
CREATE TABLE
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:295: NOTICE:  CREATE TABLE will create implicit sequence "weight_assoc_id_seq" for serial column "weight_assoc.id"
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:295: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "weight_assoc_pkey" for table "weight_assoc"
CREATE TABLE
CREATE INDEX
INSERT 0 4
INSERT 0 4
INSERT 0 1
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:636: ERROR:  cannot change name of input parameter "dest_usr"
HINT:  Use DROP FUNCTION first.
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:653: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:712: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:714: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:716: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:720: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:722: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:725: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:726: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:728: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:758: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:760: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:790: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:792: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:794: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:814: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:816: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:847: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:849: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:880: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:882: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:902: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:940: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:961: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:964: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:967: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:968: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:969: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:970: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:973: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:986: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:988: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1173: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1177: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1181: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1213: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1244: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1246: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1277: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1309: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1315: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1319: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1323: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1327: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1332: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1336: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1364: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1372: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1380: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1383: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1384: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1385: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1386: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1387: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1388: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1389: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1390: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1391: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1392: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1393: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1394: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1395: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1396: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1397: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1398: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1399: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1400: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1401: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1402: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1403: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1404: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1405: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1406: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1407: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1408: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1409: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1411: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1413: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1415: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1416: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1417: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1418: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1433: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1435: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1437: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1438: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1439: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1440: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1441: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1442: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1443: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1445: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1446: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1447: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1448: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1449: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1450: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1451: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1453: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1454: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1456: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1457: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1458: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1459: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1460: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1461: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1462: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1467: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1468: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1469: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1470: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1473: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1492: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1494: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1500: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1536: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1540: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1561: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1565: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1567: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1592: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1596: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1632: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1636: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1794: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1796: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1800: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1804: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1808: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1812: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1816: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1840: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1852: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1857: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1861: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1865: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1869: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:1873: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2094: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2097: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2098: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2099: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2100: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2101: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2103: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2104: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2105: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2106: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2107: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2110: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2111: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2112: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2113: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2114: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2115: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2116: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2117: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2118: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2120: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2121: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2122: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2123: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2124: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2125: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2126: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2127: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2128: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2131: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2132: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2212: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2241: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2246: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2247: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2254: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2260: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2274: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2277: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2280: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2285: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2288: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2292: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2293: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2294: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2319: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2325: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2331: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2335: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2336: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2337: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2523: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2527: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2531: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2534: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2538: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2547: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2563: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2565: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2571: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2572: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2579: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2595: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2597: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2598: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2599: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2606: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2607: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2608: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2609: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2611: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2612: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2614: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2618: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2622: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2624: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2637: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2642: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2643: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2644: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2645: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2646: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2647: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2648: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2649: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2650: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2651: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2652: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2653: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2654: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2655: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2656: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2657: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2658: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2659: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2662: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2665: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2667: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2668: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2670: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2671: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2672: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2674: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2675: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2676: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2678: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2682: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2694: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2702: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2705: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2706: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2707: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2708: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2709: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2710: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2711: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2712: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2713: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2714: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2715: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2716: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2717: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2718: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2719: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2720: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2721: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2722: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2723: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2724: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2725: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2727: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2728: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2755: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2810: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2890: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2962: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:2984: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:3026: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:3048: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:3071: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:3096: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:3112: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:3127: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:3142: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:3176: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:3189: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:3202: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:3216: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:3231: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:3264: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:3306: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:3343: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:3386: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:3401: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:3416: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:3439: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:3441: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:3443: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:3458: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:3460: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:3461: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:3467: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:3474: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:3475: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:3476: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:3478: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:3484: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:3491: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:3493: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:3576: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:3626: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:3660: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:3663: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:3665: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:3666: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:3667: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:3668: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:3865: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:3868: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:3870: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:4029: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:4059: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:4151: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:4246: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:4253: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:4283: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:4320: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:4415: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:4419: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:4421: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:4423: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:4425: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:4435: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:4443: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:4452: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:4613: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:4615: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:4618: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:4620: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:4623: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:4625: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:4627: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:4804: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:4947: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:5070: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:5139: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:5215: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:5294: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:5356: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:5400: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:5434: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:5438: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:5441: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:5444: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:5484: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:5664: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:5670: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:5672: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:5678: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:5683: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:5685: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:5714: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:5730: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:5739: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:5741: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:5750: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:5759: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:5768: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:5777: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:5786: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:5838: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:5858: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:5886: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:5968: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:5988: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:6015: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:6035: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:6054: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:6074: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:6106: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:6133: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:6165: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:6190: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:6212: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:6233: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:6254: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:6275: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:6296: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:6317: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:6319: ERROR:  current transaction is aborted, commands ignored until end of transaction block
This might not insert much if you passed through 0542 on your way here,
but one group was missed there as well
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:6373: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:6401: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:6421: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:6449: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:6531: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:6533: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:6550: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:6552: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:6567: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:6569: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:6766: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:6768: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:6772: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:6783: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:6785: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:6878: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:6964: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:6990: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:7048: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:7074: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:7101: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:7130: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:7164: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:7230: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:7298: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:7300: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:7508: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:7510: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:7533: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:7535: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:7544: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:7546: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:7580: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:7584: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:7588: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:7608: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:7610: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:7633: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:7637: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:7845: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:7847: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:7887: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:7950: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:7952: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:7959: ERROR:  current transaction is aborted, commands ignored until end of transaction block
To reindex bibs that use the author|other index definition,
you can run something like this:

SELECT metabib.reingest_metabib_field_entries(record)
FROM (
SELECT DISTINCT record
FROM metabib.real_full_rec
WHERE tag IN ('600', 700 , 720 , 800 )
AND subfield IN ('4', e )
) a;
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:7974: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:8006: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:8012: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:8043: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:8045: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:8253: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:8255: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:8256: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:8448: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:8452: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:8460: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:8461: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:8462: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:8463: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:8464: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:8471: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:8479: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:8487: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:8493: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:8499: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:8503: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:8822: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:8825: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:8826: ERROR:  current transaction is aborted, commands ignored until end of transaction block
ROLLBACK
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:8850: ERROR:  insert or update on table "org_unit_setting_type" violates foreign key constraint "org_unit_setting_type_grp_fkey"
DETAIL:  Key (grp)=(circ) is not present in table "settings_group".
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
DROP TRIGGER
DROP TRIGGER
DROP TRIGGER
CREATE TRIGGER
CREATE TRIGGER
CREATE TRIGGER
DROP TRIGGER
DROP TRIGGER
DROP TRIGGER
CREATE TRIGGER
CREATE TRIGGER
CREATE TRIGGER
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:8908: ERROR:  relation "metabib.record_attr" does not exist
LINE 1: UPDATE  metabib.record_attr
                ^
psql:Open-ILS/src/sql/Pg/2.0-2.1-upgrade-db.sql:8917: ERROR:  relation "metabib.record_attr" does not exist
LINE 1: UPDATE  metabib.record_attr
                ^

Relevant code next to line 636:


        -- vandelay.*
        -- Update with a rename to avoid collisions
        FOR renamable_row in
                SELECT id, name
                FROM   vandelay.queue
                WHERE  owner = src_usr
        LOOP
                suffix := ' (' || src_usr || ')';
                LOOP
                        BEGIN
                                UPDATE  vandelay.queue
                                SET     owner = dest_usr, name = name || suffix
                                WHERE   id = renamable_row.id;
                        EXCEPTION WHEN unique_violation THEN
                                suffix := suffix || ' ';
                                CONTINUE;
                        END;
                        EXIT;
                END LOOP;
        END LOOP;

END;