aboutsummaryrefslogtreecommitdiff
path: root/src/backend/storage/buffer/buf_init.c
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2001-07-04 17:36:54 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2001-07-04 17:36:54 +0000
commit499c81d3a3ffef4645b720ace5909f00609bff79 (patch)
tree76c9321a8091df9027e47583f6f7fdb2f1b5d1b3 /src/backend/storage/buffer/buf_init.c
parent5621ec0629b1da42869375210b2a90e6605dd9f0 (diff)
downloadpostgresql-499c81d3a3ffef4645b720ace5909f00609bff79.tar.gz
postgresql-499c81d3a3ffef4645b720ace5909f00609bff79.zip
Prohibit a column from appearing twice in a PRIMARY KEY or UNIQUE
constraint. This case (a) is useless, (b) violates SQL92, and (c) is certain to cause a failure downstream when we try to create an index with duplicated column names. So give an appropriate error message instead of letting the index failure occur. Per report from Colin Strickland. NOTE: currently, CREATE INDEX fooi ON foo(f1,f1) still fails with 'cannot insert duplicate key' error. Should we change that too? What about functional indexes?
Diffstat (limited to 'src/backend/storage/buffer/buf_init.c')
0 files changed, 0 insertions, 0 deletions