From a438ebb666b3fb1cc163398c62bb56fee7845c9a Mon Sep 17 00:00:00 2001 From: dbs Date: Tue, 25 Nov 2008 22:47:30 +0000 Subject: [PATCH] TEXT and BIGINT don't play nicely together, especially in PostgreSQL 8.3 Perhaps this mismatch is part of the reason for some reported sluggishness in Vandelay import in 1.4? git-svn-id: svn://svn.open-ils.org/ILS/trunk@11350 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/012.schema.vandelay.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/012.schema.vandelay.sql b/Open-ILS/src/sql/Pg/012.schema.vandelay.sql index 737b3ec77f..dbdd1575c9 100644 --- a/Open-ILS/src/sql/Pg/012.schema.vandelay.sql +++ b/Open-ILS/src/sql/Pg/012.schema.vandelay.sql @@ -69,7 +69,7 @@ CREATE TABLE vandelay.import_item_attr_definition ( CREATE TABLE vandelay.bib_queue ( queue_type TEXT NOT NULL DEFAULT 'bib' CHECK (queue_type = 'bib'), - item_attr_def TEXT REFERENCES vandelay.import_item_attr_definition (id) ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED, + item_attr_def BIGINT REFERENCES vandelay.import_item_attr_definition (id) ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED, CONSTRAINT vand_bib_queue_name_once_per_owner_const UNIQUE (owner,name,queue_type) ) INHERITS (vandelay.queue); ALTER TABLE vandelay.bib_queue ADD PRIMARY KEY (id); -- 2.11.0