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 [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]