diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2004-06-10 17:56:03 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2004-06-10 17:56:03 +0000 |
| commit | 45616f5bbbb87745e0e82b00e77562d6502aa042 (patch) | |
| tree | 18d24d180f5c0c954268e64f5b6fe62922fc106e /src/test/regress/sql/copy2.sql | |
| parent | 75db5a665fac305ac0170f49f39c1b01d026e8d3 (diff) | |
| download | postgresql-45616f5bbbb87745e0e82b00e77562d6502aa042.tar.gz | |
Clean up generation of default names for constraints, indexes, and serial
sequences, as per recent discussion. All these names are now of the
form table_column_type, with digits added if needed to make them unique.
Default constraint names are chosen to be unique across their whole schema,
not just within the parent object, so as to be more SQL-spec-compatible
and make the information schema views more useful.
Diffstat (limited to 'src/test/regress/sql/copy2.sql')
| -rw-r--r-- | src/test/regress/sql/copy2.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/test/regress/sql/copy2.sql b/src/test/regress/sql/copy2.sql index 35c376d1e3..70c8ea6b1e 100644 --- a/src/test/regress/sql/copy2.sql +++ b/src/test/regress/sql/copy2.sql @@ -129,6 +129,6 @@ COPY y TO stdout WITH CSV; COPY y TO stdout WITH CSV QUOTE '''' DELIMITER '|'; COPY y TO stdout WITH CSV FORCE QUOTE col2 ESCAPE '\\'; -DROP TABLE x; +DROP TABLE x, y; DROP FUNCTION fn_x_before(); DROP FUNCTION fn_x_after(); |