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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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