Skip site navigation (1) Skip section navigation (2)


From: Christopher <chriskl(at)familyhealth(dot)com(dot)au>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: DROP CONSTRAINT patch
Date: 2001-05-20 07:50:07
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
Hi all,

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.

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...


Attachment: dropcons.diff
Description: text/plain (11.1 KB)


pgsql-hackers by date

Next:From: mlwDate: 2001-05-20 12:06:55
Subject: Re: External search engine, advice
Previous:From: mordicusDate: 2001-05-20 07:47:29
Subject: RE: Re: Functions returning sets

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group