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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: spurious "UNIQUE constraint matching given keys for referenced table" error
Дата
Msg-id 14719.1034691203@sss.pgh.pa.us
обсуждение исходный текст
Ответ на spurious "UNIQUE constraint matching given keys for referenced table" error  ("Mathew Frank" <mathewfrank@qushi.com>)
Список pgsql-bugs
Дерево обсуждения 
"Mathew Frank" <mathewfrank@qushi.com> writes:
> UNIQUE constraint matching given keys for referenced table "price_lists" not
> found

As of CVS tip your example gives

ERROR:  ALTER TABLE: column "s_price_list_id" referenced in foreign key constraint does not exist

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 :-(

            regards, tom lane

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

Предыдущее
От: ftm.van.vugt@foxi.nl
Дата:
Сообщение: multiple exception definition in pg_type.h -> error compiling postgres support in Qt with gcc v3.2 (SuSE 8.1)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: multiple exception definition in pg_type.h -> error compiling postgres support in Qt with gcc v3.2 (SuSE 8.1)