Peter Eisentraut wrote: > Neil Conway writes: > > > Should this produce a warning? > > > > nconway=# create table a (b int4 unique); > > NOTICE: CREATE TABLE / UNIQUE will create implicit index "a_b_key" for > > table "a" > > CREATE TABLE > > nconway=# create table c (d int8 references a (b)); > > NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY > > check(s) > > CREATE TABLE > > I don't think so. We don't produce warnings in other cases of potential > index mismatches either.
The issue is that it isn't likely someone would be doing a foreign key mismatch, while a mismatch in a query would be more likely. We could make it a HINT and then people could configure their servers to suppress the hint if they wish. -- 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 6: Have you searched our list archives? http://archives.postgresql.org
