| 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: | Whole Thread | Raw Message | 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? |