From 392b187a214272937557af695692b6586375cc66 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Fri, 1 Oct 2004 15:43:40 +0000 Subject: [PATCH] Remove DROPs from contrib object creation scripts, per Dave Page. --- contrib/intagg/int_aggregate.sql.in | 3 +-- contrib/pgstattuple/pgstattuple.sql.in | 1 - 2 files changed, 1 insertion(+), 3 deletions(-) diff --git a/contrib/intagg/int_aggregate.sql.in b/contrib/intagg/int_aggregate.sql.in index 31279c5b33..8a7d9b3238 100644 --- a/contrib/intagg/int_aggregate.sql.in +++ b/contrib/intagg/int_aggregate.sql.in @@ -15,9 +15,8 @@ RETURNS int4[] AS 'MODULE_PATHNAME','int_agg_final_array' LANGUAGE 'C' IMMUTABLE STRICT; --- The aggration funcion. +-- The aggregate function itself -- uses the above functions to create an array of integers from an aggregation. -DROP AGGREGATE int_array_aggregate(int4); CREATE AGGREGATE int_array_aggregate ( BASETYPE = int4, SFUNC = int_agg_state, diff --git a/contrib/pgstattuple/pgstattuple.sql.in b/contrib/pgstattuple/pgstattuple.sql.in index b75c845159..f7eac5040f 100644 --- a/contrib/pgstattuple/pgstattuple.sql.in +++ b/contrib/pgstattuple/pgstattuple.sql.in @@ -1,7 +1,6 @@ -- Adjust this setting to control where the objects get created. SET search_path = public; -DROP TYPE pgstattuple_type CASCADE; CREATE TYPE pgstattuple_type AS ( table_len BIGINT, -- physical table length in bytes tuple_count BIGINT, -- number of live tuples -- 2.40.0