pg_get_constraintdef patch #2 - Mailing list pgsql-patches

From Christopher Kings-Lynne
Subject pg_get_constraintdef patch #2
Date
Msg-id GNELIHDDFBOCMGBFGEFOCEPOCEAA.chriskl@familyhealth.com.au
Whole thread Raw
Responses Re: pg_get_constraintdef patch #2  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: pg_get_constraintdef patch #2  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-patches
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

pgsql-patches by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: Add UNIQUE and PRIMARY KEY to pg_get_constraintdef
Next
From: Lee Kindness
Date:
Subject: Re: [HACKERS] PostgreSQL libraries - PThread Support, but