Re: Exclude constraint problem - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Exclude constraint problem
Date
Msg-id 19147.1283211177@sss.pgh.pa.us
Whole thread Raw
In response to Exclude constraint problem  (Alex Zepeda <zipzippy@sonic.net>)
List 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 by date:

Previous
From: Jeff Davis
Date:
Subject: Re: Exclude constraint problem
Next
From: Tom Lane
Date:
Subject: Re: Exclude constraint problem