Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

Next:From: Tom LaneDate: 2010-08-30 23:40:14
Subject: Re: Exclude constraint problem
Previous:From: Jeff DavisDate: 2010-08-30 23:23:22
Subject: Re: Exclude constraint problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group