OSDN Git Service

Attached is my patch that adds DROP CONSTRAINT support to PostgreSQL. I
authorBruce Momjian <bruce@momjian.us>
Wed, 30 May 2001 12:57:36 +0000 (12:57 +0000)
committerBruce Momjian <bruce@momjian.us>
Wed, 30 May 2001 12:57:36 +0000 (12:57 +0000)
commit36546c98b5b59c2e222b938d49434514769bbb87
treef3082f32373473cfd30d7c020a64b9ab1af5fdba
parent7d4854f85cbe6c767c5e51a1112cefab17247ba0
Attached is my patch that adds DROP CONSTRAINT support to PostgreSQL.  I
basically want your guys feedback.  I have sprinkled some of my q's thru
the text delimited with the @@ symbol.  It seems to work perfectly.

[ Removed @@ comments because patch was reviewed. ]

At the moment it does CHECK constraints only, with inheritance.  However,
due to the problem mentioned before with the mismatching between inherited
constraints it may be wise to disable the inheritance feature for a while.
it is written in an extensible fashion to support future dropping of other
types of constraint, and is well documented.

Please send me your comments, check my use of locking, updating of
indices, use of ERROR and NOTICE, etc. and I will rework the patch based
on feedback until everyone
is happy with it...

Christopher Kings
src/backend/catalog/heap.c
src/backend/commands/command.c
src/include/catalog/heap.h