From 5e43a00948a7650ea7d16b9772f90aa81dc5078a Mon Sep 17 00:00:00 2001 From: dbs Date: Wed, 16 Mar 2011 03:38:26 +0000 Subject: [PATCH] Make DROP statement match new basetype for agg_tsvector When the CREATE AGGREGATE function was changed to have a basetype of pg_catalog.agg_tsvector, the corresponding DROP statement was not changed in a similar fashion; ergo, on creating the schema a subsequent time, the CREATE statement would fail because the aggregate function already existed and the transaction would be rolled back. Also - do we need to differentiate between PostgreSQL 8.4 and 9.0 here? git-svn-id: svn://svn.open-ils.org/ILS/trunk@19758 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/002.functions.aggregate.sql | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/Open-ILS/src/sql/Pg/002.functions.aggregate.sql b/Open-ILS/src/sql/Pg/002.functions.aggregate.sql index 26d908f..bf4fcfa 100644 --- a/Open-ILS/src/sql/Pg/002.functions.aggregate.sql +++ b/Open-ILS/src/sql/Pg/002.functions.aggregate.sql @@ -21,7 +21,7 @@ DROP AGGREGATE IF EXISTS array_accum(anyelement) CASCADE; DROP AGGREGATE IF EXISTS public.first(anyelement) CASCADE; DROP AGGREGATE IF EXISTS public.last(anyelement) CASCADE; DROP AGGREGATE IF EXISTS public.agg_text(text) CASCADE; -DROP AGGREGATE IF EXISTS public.agg_tsvector(tsvector) CASCADE; +DROP AGGREGATE IF EXISTS public.agg_tsvector(pg_catalog.tsvector) CASCADE; CREATE AGGREGATE array_accum ( sfunc = array_append, -- 1.7.2.5