Postgres Pro
Downloads
Home   >   mailing lists

Re: spurious "UNIQUE constraint matching given keys for referenced table" error - Mailing list pgsql-bugs

From Mathew Frank
Subject Re: spurious "UNIQUE constraint matching given keys for referenced table" error
Date
Msg-id 044301c274a6$78a83d40$0a00a8c0@dax
Whole thread Raw
In response to spurious "UNIQUE constraint matching given keys for referenced table" error  ("Mathew Frank" <mathewfrank@qushi.com>)
Responses Re: spurious "UNIQUE constraint matching given keys for referenced table" error  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
> 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

pgsql-bugs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: multiple exception definition in pg_type.h -> error
Next
From: Tom Lane
Date:
Subject: Re: spurious "UNIQUE constraint matching given keys for referenced table" error