'on insert do instead' rule with a where clause responds 'INSERT 0 0'

From: Julius Stroffek <Julius(dot)Stroffek(at)sun(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: 'on insert do instead' rule with a where clause responds 'INSERT 0 0'
Date: 2007-09-07 14:29:44
Message-ID: 46E16058.4070602@Sun.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-jdbc

Hi,

Attached is the example script 'repro.sql' which creates two relations
tab1 and tab2. It also creates a rule on tab1 which simply does insert
into tab2. The insert statement into tab1 is executed afterwards. It
responds with 'INSERT 0 1'. However if I would create the same rule with
the where clause the response to the same insert statement is 'INSERT 0
0'. The output of the script executed through psql is in 'repro.out'.

Is this a bug? Is there any reason why the second insert should respond
'INSERT 0 0' instead of 'INSERT 0 1'? Thanks.

Cheers

Julo

Attachment Content-Type Size
repro.out text/plain 195 bytes
repro.sql text/x-sql 488 bytes

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2007-09-07 15:36:03 Re: 'on insert do instead' rule with a where clause responds 'INSERT 0 0'
Previous Message Hiroshi Saito 2007-09-07 05:20:20 Re: BUG #3601: When we try to connect to postgres ti shows Unicode converter buffer overflow error.

Browse pgsql-jdbc by date

  From Date Subject
Next Message Heikki Linnakangas 2007-09-07 15:05:37 Re: Fwd: Caching driver on pgFoundry?
Previous Message László Hornyák 2007-09-07 13:56:55 Fwd: Caching driver on pgFoundry?