Re: Exclude constraint problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alex Zepeda <zipzippy(at)sonic(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Exclude constraint problem
Date: 2010-08-30 23:32:57
Message-ID: 19147.1283211177@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Alex Zepeda <zipzippy(at)sonic(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2010-08-30 23:40:14 Re: Exclude constraint problem
Previous Message Jeff Davis 2010-08-30 23:23:22 Re: Exclude constraint problem