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 |
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. |
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? |