]> granicus.if.org Git - postgresql/commit
Clean up generation of default names for constraints, indexes, and serial
authorTom Lane <tgl@sss.pgh.pa.us>
Thu, 10 Jun 2004 17:56:03 +0000 (17:56 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Thu, 10 Jun 2004 17:56:03 +0000 (17:56 +0000)
commit45616f5bbbb87745e0e82b00e77562d6502aa042
tree18d24d180f5c0c954268e64f5b6fe62922fc106e
parent75db5a665fac305ac0170f49f39c1b01d026e8d3
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.
20 files changed:
src/backend/catalog/heap.c
src/backend/catalog/pg_constraint.c
src/backend/commands/indexcmds.c
src/backend/commands/tablecmds.c
src/backend/commands/typecmds.c
src/backend/parser/analyze.c
src/include/catalog/pg_constraint.h
src/include/commands/defrem.h
src/include/parser/analyze.h
src/test/regress/expected/alter_table.out
src/test/regress/expected/cluster.out
src/test/regress/expected/copy2.out
src/test/regress/expected/domain.out
src/test/regress/expected/foreign_key.out
src/test/regress/expected/namespace.out
src/test/regress/expected/rules.out
src/test/regress/expected/sequence.out
src/test/regress/expected/truncate.out
src/test/regress/output/constraints.source
src/test/regress/sql/copy2.sql