Unique / Primary key constraints
Unique and primary key constraints are both dumped using ALTER TABLE
statements. Unique indexes with CREATE INDEX.
Basically, pg_constraint left outer'd to pg_index.
Attachments:
pri_uniq_dump.patchtext/x-patch; charset=ISO-8859-1; name=pri_uniq_dump.patchDownload+42-42
Your patch has been added to the PostgreSQL unapplied patches list at:
http://candle.pha.pa.us/cgi-bin/pgpatches
I will try to apply it within the next 48 hours.
---------------------------------------------------------------------------
Rod Taylor wrote:
Unique and primary key constraints are both dumped using ALTER TABLE
statements. Unique indexes with CREATE INDEX.Basically, pg_constraint left outer'd to pg_index.
[ Attachment, skipping... ]
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026Patch applied. Thanks.
---------------------------------------------------------------------------
Rod Taylor wrote:
Unique and primary key constraints are both dumped using ALTER TABLE
statements. Unique indexes with CREATE INDEX.Basically, pg_constraint left outer'd to pg_index.
[ Attachment, skipping... ]
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026