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] multiple exception definition in pg_type.h -> error

2002-10-15 Thread Peter Eisentraut
Tom Lane writes: > [EMAIL PROTECTED] writes: > > Postgresql itself seems to never include along with > > , otherwise it would suffer from the same problem > > That's hard to believe; I think it's Qt that's doing something strange > here. Yeah, like compiling with thread support. ;-) > Anyone o

Re: [BUGS] multiple exception definition in pg_type.h -> error compiling postgres support in Qt with gcc v3.2 (SuSE 8.1)

2002-10-15 Thread Tom Lane
[EMAIL PROTECTED] writes: > Postgresql itself seems to never include along with > , otherwise it would suffer from the same problem That's hard to believe; I think it's Qt that's doing something strange here. Still, the ANSI C standard does discourage what we are doing: ... It is unsp

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] multiple exception definition in pg_type.h -> error compiling postgres support in Qt with gcc v3.2 (SuSE 8.1)

2002-10-15 Thread ftm . van . vugt
Your name : Frank van Vugt Your email address : [EMAIL PROTECTED] (with thanks to Dimitri@TrollTech for his insight & examples) System Configuration - Architecture : Intel Pentium III Operating System : Linux 2.4.19 with g

[BUGS] Bug #797: Inaccurate in PostgreSQL 7.3b2 Developer's Guide

2002-10-15 Thread pgsql-bugs
Piotr Kuczynski ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description Inaccurate in PostgreSQL 7.3b2 Developer's Guide Long Description There is small inaccurate in the "PostgreSQL 7.3b2 Developer's Guide": [Chapter 10. Native Langu