Re: Referencing "less-unique" foreign keys

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Referencing "less-unique" foreign keys
Дата
Msg-id 16323.1123600689@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Referencing "less-unique" foreign keys  (Richard Huxton <dev@archonet.com>)
Список pgsql-general
Richard Huxton <dev@archonet.com> writes:
> Alban Hertroys wrote:
>> I'm not sure how we got the "content" column from "description" to
>> reference "localization" back in version 7.3. Fact is, we can't seem to
>> do this anymore since version 7.4:

> I don't have 7.3.x to hand any more, but if you could create such a
> reference it was a bug.

Having just tried it, I can say that the last version that would take
that without complaint is 7.0.  7.1 and later give variants of

ERROR:  UNIQUE constraint matching given keys for referenced table "localization" not found

So I'm not sure what Alban actually did.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Query stucked in pg_stat_activity
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: Reference new.* or old.* in dynamic statement?