Thread: pg_get_constraintdef patch #2
Hi, This patch supercedes the previous version. Apply this instead of the previous version. This patch makes pg_get_constraintdef support UNIQUE, PRIMARY KEY and CHECK constraints. There are apparently no other types of constraint in pg_constraint, so now all bases are covered. Also, this patch assumes that consrc for a CHECK constraint is always bracketed so that it's not necessary to add extra brackets. Chris
Attachment
Your patch has been added to the PostgreSQL unapplied patches list at:
http://momjian.postgresql.org/cgi-bin/pgpatches
I will try to apply it within the next 48 hours.
---------------------------------------------------------------------------
Christopher Kings-Lynne wrote:
> Hi,
>
> This patch supercedes the previous version. Apply this instead of the
> previous version.
>
> This patch makes pg_get_constraintdef support UNIQUE, PRIMARY KEY and CHECK
> constraints.
>
> There are apparently no other types of constraint in pg_constraint, so now
> all bases are covered. Also, this patch assumes that consrc for a CHECK
> constraint is always bracketed so that it's not necessary to add extra
> brackets.
>
> Chris
[ Attachment, skipping... ]
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
Patch applied. Thanks. --------------------------------------------------------------------------- Christopher Kings-Lynne wrote: > Hi, > > This patch supercedes the previous version. Apply this instead of the > previous version. > > This patch makes pg_get_constraintdef support UNIQUE, PRIMARY KEY and CHECK > constraints. > > There are apparently no other types of constraint in pg_constraint, so now > all bases are covered. Also, this patch assumes that consrc for a CHECK > constraint is always bracketed so that it's not necessary to add extra > brackets. > > Chris [ Attachment, skipping... ] > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073