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(at)gmx(dot)net