summaryrefslogtreecommitdiff
path: root/src/test/regress/sql/drop.sql
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2001-10-03 20:54:22 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2001-10-03 20:54:22 +0000
commit2e5fda7b7e0613b4b7c69d69b609e639deac7c17 (patch)
treecb76595ec5aa439e05891df3209e08a9b537247d /src/test/regress/sql/drop.sql
parent16def00ffb3397b8cf1344534fbfd1f3b2cfd33d (diff)
downloadpostgresql-2e5fda7b7e0613b4b7c69d69b609e639deac7c17.tar.gz
DROP AGGREGATE and COMMENT ON AGGREGATE now accept the expected syntax
'aggname (aggtype)'. The old syntax 'aggname aggtype' is still accepted for backwards compatibility. Fix pg_dump, which was actually broken for most cases of user-defined aggregates. Clean up error messages associated with these commands.
Diffstat (limited to 'src/test/regress/sql/drop.sql')
-rw-r--r--src/test/regress/sql/drop.sql6
1 files changed, 3 insertions, 3 deletions
diff --git a/src/test/regress/sql/drop.sql b/src/test/regress/sql/drop.sql
index fc89483208..a466e6f7c2 100644
--- a/src/test/regress/sql/drop.sql
+++ b/src/test/regress/sql/drop.sql
@@ -73,11 +73,11 @@ DROP TYPE widget;
--
-- AGGREGATE REMOVAL
--
-DROP AGGREGATE newavg int4;
+DROP AGGREGATE newavg (int4);
-DROP AGGREGATE newsum int4;
+DROP AGGREGATE newsum (int4);
-DROP AGGREGATE newcnt int4;
+DROP AGGREGATE newcnt (int4);
--