Re: FK type mismatches?

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 pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073