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

2002-10-15 Thread Tom Lane
"Mathew Frank" <[EMAIL PROTECTED]> 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

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

2002-10-15 Thread Mathew Frank
> 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.

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

2002-10-15 Thread Tom Lane
"Mathew Frank" <[EMAIL PROTECTED]> writes: > UNIQUE constraint matching given keys for referenced table "price_lists" not > found As of CVS tip your example gives ERROR: ALTER TABLE: column "s_price_list_id" referenced in foreign key constraint does not exist which appears correct (you misspe

[BUGS] spurious "UNIQUE constraint matching given keys for referenced table" error

2002-10-14 Thread Mathew Frank
Hello people, I'm a newbie to this list (though I've been hanging around on the ODBC list for some time and I've been working with pgSQL for about 8months) so go easy? ;-) I realise this error is to stop a bad foreign key reference being created. However I have a table with a multi-column primary