Re: FK type mismatches?

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.

Robert Treat
-- 
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL