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

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

From: "Mathew Frank" <mathewfrank(at)qushi(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: spurious "UNIQUE constraint matching given keys for referenced table" error
Date: 2002-10-15 23:56:25
Message-ID: 044301c274a6$78a83d40$0a00a8c0@dax (view raw or flat)
Thread:
Lists: pgsql-bugs
> which appears correct (you misspelled the column name).
>
> 7.2 does foreign key validity checking in a funny order that causes it
> to produce the other error message first.  While not incorrect, it's
> sure misleading :-(

Thanks a bunch.

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 ;)

Cheers,
Mathew


In response to

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2002-10-16 03:11:55
Subject: Re: spurious "UNIQUE constraint matching given keys for referenced table" error
Previous:From: Peter EisentrautDate: 2002-10-15 18:59:44
Subject: Re: multiple exception definition in pg_type.h -> error

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