From be8d28683b3207dd7fd13fb2d0d0994e4a7974e4 Mon Sep 17 00:00:00 2001 From: dbs Date: Tue, 7 Apr 2009 14:07:07 +0000 Subject: [PATCH] Reverting the unique index on bre.id; it's a primary key and already has one by definition Creating the index probably improved the speed of ingest as a side effect; a reindex would probably have the same effect without additional index overhead. More investigation required. git-svn-id: svn://svn.open-ils.org/ILS/trunk@12812 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/010.schema.biblio.sql | 1 - 1 file changed, 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/010.schema.biblio.sql b/Open-ILS/src/sql/Pg/010.schema.biblio.sql index 3a9fdb5be8..b171801360 100644 --- a/Open-ILS/src/sql/Pg/010.schema.biblio.sql +++ b/Open-ILS/src/sql/Pg/010.schema.biblio.sql @@ -41,7 +41,6 @@ CREATE TABLE biblio.record_entry ( marc TEXT NOT NULL, last_xact_id TEXT NOT NULL ); -CREATE UNIQUE INDEX biblio_record_entry_unique ON biblio.record_entry ( id ); CREATE INDEX biblio_record_entry_creator_idx ON biblio.record_entry ( creator ); CREATE INDEX biblio_record_entry_create_date_idx ON biblio.record_entry ( create_date ); CREATE INDEX biblio_record_entry_editor_idx ON biblio.record_entry ( editor ); -- 2.11.0