Robert Treat wrote: > On Fri, 2003-09-05 at 17:06, 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. > > > > In all this discussion of NOTICE vs. WARNING, can someone remind me the > logic for INFO? I can't seem to recall the differentiator there either.
Right now I see INFO being used mostly for vacuum status. -- 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 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
