Patch applied to HEAD and 7.3.X. Thanks. ---------------------------------------------------------------------------
Rod Taylor wrote: -- Start of PGP signed section. > If they're not, the below causes problems, as the foreign key is added > after the CHECK. Cluster depends on the index name, so I thought it > wise to ensure all names are available, rather than leaving off the > CONSTRAINT "$n" portion for internally named constraints. > > CREATE TABLE jkey (col integer primary key); > CREATE TABLE j (col integer REFERENCES jkey); > ALTER TABLE j ADD CHECK(col > 5); > > > This is a problem in 7.3 series as well as -Tip. > > -- > Rod Taylor <[EMAIL PROTECTED]> > > PGP Key: http://www.rbt.ca/rbtpub.asc [ Attachment, skipping... ] -- End of PGP section, PGP failed! -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings