summaryrefslogtreecommitdiff
path: root/contrib
diff options
context:
space:
mode:
Diffstat (limited to 'contrib')
-rw-r--r--contrib/intagg/int_aggregate.sql.in3
-rw-r--r--contrib/pgstattuple/pgstattuple.sql.in1
2 files changed, 1 insertions, 3 deletions
diff --git a/contrib/intagg/int_aggregate.sql.in b/contrib/intagg/int_aggregate.sql.in
index 31279c5b33f..8a7d9b32386 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 b75c8451592..f7eac5040f9 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