diff options
| author | Tom Lane | 2004-10-01 15:43:40 +0000 |
|---|---|---|
| committer | Tom Lane | 2004-10-01 15:43:40 +0000 |
| commit | 392b187a214272937557af695692b6586375cc66 (patch) | |
| tree | f275a396abf0bf7bc8c58219905fef86444cb47d | |
| parent | b3f2f6ebec374012bd25ad5acda196d27c33e29a (diff) | |
Remove DROPs from contrib object creation scripts, per Dave Page.
| -rw-r--r-- | contrib/intagg/int_aggregate.sql.in | 3 | ||||
| -rw-r--r-- | contrib/pgstattuple/pgstattuple.sql.in | 1 |
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 |