Re: pg_get_constraintdef - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: pg_get_constraintdef
Date
Msg-id GNELIHDDFBOCMGBFGEFOGEPKCEAA.chriskl@familyhealth.com.au
Whole thread Raw
In response to Re: pg_get_constraintdef  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pg_get_constraintdef  ("Ross J. Reedstrom" <reedstrm@rice.edu>)
List pgsql-hackers
> "Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
> > Is there some reason why pg_get_constraintdef only supports Foreign Key
> > constraints?
>
> Lack of implementation effort --- the original definition/implementation
> was FK-specific, but now, as the code says,
>
>  * XXX The present implementation only works for foreign-key
> constraints, but
>  * it could and should handle anything pg_constraint stores.
>
> Feel free to contribute some code.

I will, but unfortunately the damage has already been done...since I have to
support 7.3 anyway, fixing the above problem will actually make my life
harder, not easier...

Chris



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_get_constraintdef
Next
From: Kevin Brown
Date:
Subject: Re: sync()