[BUGS] BUG #2251: NOT IN clause is not working correctly

2006-02-10 Thread Sergei Dubov
The following bug has been logged online: Bug reference: 2251 Logged by: Sergei Dubov Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.2 Operating system: Windows XP Description:NOT IN clause is not working correctly Details: I have two tables, let's say A a

Re: [BUGS] overlapping rules can let you break referential integrity

2006-02-10 Thread Tom Lane
"Denis de Bernardy" <[EMAIL PROTECTED]> writes: > Step by step how to reproduce: This is not a bug, it's a feature. regards, tom lane ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[BUGS] overlapping rules can let you break referential integrity

2006-02-10 Thread Denis de Bernardy
Step by step how to reproduce: -- nodes CREATE TABLE nodes ( node_id serial, CONSTRAINT nodes_pkey PRIMARY KEY (node_id) ) WITHOUT OIDS; -- domains CREATE TABLE domains ( domain_id int NOT NULL, domain_is_p

Re: [BUGS] BUG #2250: JSTL parameterized queries inserting numeric

2006-02-10 Thread Kris Jurka
On Thu, 9 Feb 2006, Ian Moore wrote: The following bug has been logged online: Bug reference: 2250 PostgreSQL version: 8.0.3 Description:JSTL parameterized queries inserting numeric values Details: When using the JSTL via JDBC, there is the option to write INSERT/UPDATE stateme