Re: Exclude constraint problem

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Exclude constraint problem
Дата
Msg-id 19147.1283211177@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Exclude constraint problem  (Alex Zepeda <zipzippy@sonic.net>)
Список pgsql-bugs
Alex Zepeda <zipzippy@sonic.net> writes:
> I dumped a table with an exclude constraint with pg_dump, and loaded it
> into another instance of postgres where it promptly failed to create the
> constraint.  The complaint was... key conflicts with key.  IOW,
> duplicate data.

> This should not happen, correct?  If it *should* happen, why?  If it
> shouldn't happen, where should I start looking?

Well, for starters, do the complained-of values actually violate the
constraint?

            regards, tom lane

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

Предыдущее
От: Jeff Davis
Дата:
Сообщение: Re: Exclude constraint problem
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Exclude constraint problem