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

Re: spurious "UNIQUE constraint matching given keys for referenced table" error

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Mathew Frank" <mathewfrank(at)qushi(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: spurious "UNIQUE constraint matching given keys for referenced table" error
Date: 2002-10-16 03:11:55
Message-ID: 20516.1034737915@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"Mathew Frank" <mathewfrank(at)qushi(dot)com> writes:
> I'm always a bit nervous about calling anything a bug... 9/10 is caused by a
> typo or something on behalf of the user ;)

Well, it's a two-way street: typos and other sorts of mistakes tend to
stress paths that the developers would've never thought to test.
Besides, I'm a firm believer in the notion that software should deliver
useful error messages, and PG definitely wasn't getting that done in
this case.  So complain away.  I'm glad to be able to say "we already
fixed that for the next release", but that won't always be true...

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: Talja AriDate: 2002-10-16 07:59:29
Subject: now() gives the time of the last commit, not the time it is called
Previous:From: Mathew FrankDate: 2002-10-15 23:56:25
Subject: Re: spurious "UNIQUE constraint matching given keys for referenced table" error

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