Re: spurious "UNIQUE constraint matching given keys for referenced table" error

Поиск
Список
Период
Сортировка
От Mathew Frank
Тема Re: spurious "UNIQUE constraint matching given keys for referenced table" error
Дата
Msg-id 044301c274a6$78a83d40$0a00a8c0@dax
обсуждение исходный текст
Ответ на spurious "UNIQUE constraint matching given keys for referenced table" error  ("Mathew Frank" <mathewfrank@qushi.com>)
Ответы Re: spurious "UNIQUE constraint matching given keys for referenced table" error
Список pgsql-bugs
> which appears correct (you misspelled the column name).
>
> 7.2 does foreign key validity checking in a funny order that causes it
> to produce the other error message first.  While not incorrect, it's
> sure misleading :-(

Thanks a bunch.

I'm always a bit nervous about calling anything a bug... 9/10 is caused by a
typo or something on behalf of the user ;)

Cheers,
Mathew

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: multiple exception definition in pg_type.h -> error
Следующее
От: Tom Lane
Дата:
Сообщение: Re: spurious "UNIQUE constraint matching given keys for referenced table" error