Horton

Clean up generation of default names for constraints, indexes, and serial

Tom Lane <tgl@sss.pgh.pa.us>

View on postgr.es
Commit: 45616f5bbbb87745e0e82b00e77562d6502aa042
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2004-06-10T17:56:03Z
Releases: 8.0.0 
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.

Files

PathChange+/−
src/backend/catalog/heap.c modified +70 −77
src/backend/catalog/pg_constraint.c modified +79 −74
src/backend/commands/indexcmds.c modified +121 −27
src/backend/commands/tablecmds.c modified +31 −43
src/backend/commands/typecmds.c modified +13 −11
src/backend/parser/analyze.c modified +20 −116
src/include/catalog/pg_constraint.h modified +10 −11
src/include/commands/defrem.h modified +5 −1
src/include/parser/analyze.h modified +1 −5
src/test/regress/expected/alter_table.out modified +14 −14
src/test/regress/expected/cluster.out modified +6 −6
src/test/regress/expected/copy2.out modified +2 −2
src/test/regress/expected/domain.out modified +4 −4
src/test/regress/expected/foreign_key.out modified +38 −38
src/test/regress/expected/namespace.out modified +1 −1
src/test/regress/expected/rules.out modified +4 −4
src/test/regress/expected/sequence.out modified +1 −1
src/test/regress/expected/truncate.out modified +1 −1
src/test/regress/output/constraints.source modified +4 −4
src/test/regress/sql/copy2.sql modified +1 −1