summaryrefslogtreecommitdiff
path: root/src/test/regress/sql/alter_table.sql
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2003-11-21 22:32:49 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2003-11-21 22:32:49 +0000
commit42ce74bf17478cc8a8323601deaa63950dda9923 (patch)
tree917bf7d6c05971885302cd43b8c60c16c7e12bab /src/test/regress/sql/alter_table.sql
parent0a97cb37fc29dac05fd5aa13df91ba8431faea23 (diff)
downloadpostgresql-42ce74bf17478cc8a8323601deaa63950dda9923.tar.gz
COMMENT ON casts, conversions, languages, operator classes, and
large objects. Dump all these in pg_dump; also add code to pg_dump user-defined conversions. Make psql's large object code rely on the backend for inserting/deleting LOB comments, instead of trying to hack pg_description directly. Documentation and regression tests added. Christopher Kings-Lynne, code reviewed by Tom
Diffstat (limited to 'src/test/regress/sql/alter_table.sql')
-rw-r--r--src/test/regress/sql/alter_table.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/src/test/regress/sql/alter_table.sql b/src/test/regress/sql/alter_table.sql
index 9bdc8cd1ea..33187c8352 100644
--- a/src/test/regress/sql/alter_table.sql
+++ b/src/test/regress/sql/alter_table.sql
@@ -5,6 +5,10 @@
CREATE TABLE tmp (initial int4);
+COMMENT ON TABLE tmp_wrong IS 'table comment';
+COMMENT ON TABLE tmp IS 'table comment';
+COMMENT ON TABLE tmp IS NULL;
+
ALTER TABLE tmp ADD COLUMN a int4;
ALTER TABLE tmp ADD COLUMN b name;