]> granicus.if.org Git - postgresql/commit
Fix my oversight in enabling domains-of-domains: ALTER DOMAIN ADD CONSTRAINT
authorTom Lane <tgl@sss.pgh.pa.us>
Fri, 11 May 2007 20:18:21 +0000 (20:18 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Fri, 11 May 2007 20:18:21 +0000 (20:18 +0000)
commit4a898fbb206f5fb93b4701f6f71d67715e6a1498
treead9d0e52ab4282e609eaacfb7a9588cf276614eb
parentff5ff47b5dd6d48aa5f0dd27007e1a17f9566bb5
Fix my oversight in enabling domains-of-domains: ALTER DOMAIN ADD CONSTRAINT
needs to check the new constraint against columns of derived domains too.

Also, make it error out if the domain to be modified is used within any
composite-type columns.  Eventually we should support that case, but it seems
a bit painful, and not suitable for a back-patch.  For the moment just let the
user know we can't do it.

Backpatch to 8.2, which is the only released version that allows nested
domains.  Possibly the other part should be back-patched further.
doc/src/sgml/ref/alter_domain.sgml
src/backend/commands/tablecmds.c
src/backend/commands/typecmds.c
src/include/commands/tablecmds.h
src/test/regress/expected/domain.out
src/test/regress/sql/domain.sql