Re: FK type mismatches?

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.

-- 
Peter Eisentraut   peter_e@gmx.net