Julius Stroffek <Julius(dot)Stroffek(at)sun(dot)com> writes:
> 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?
and note that you don't have an unconditional INSTEAD rule.
regards, tom lane
In response to
pgsql-bugs by date
|Next:||From: Christian PANEL||Date: 2007-09-07 16:35:44|
|Subject: BUG #3605: impossible loading|
|Previous:||From: Julius Stroffek||Date: 2007-09-07 14:29:44|
|Subject: 'on insert do instead' rule with a where clause responds 'INSERT 0 0'|
pgsql-jdbc by date
|Next:||From: Josh Berkus||Date: 2007-09-07 17:04:43|
|Subject: Re: Caching driver on pgFoundry?|
|Previous:||From: Heikki Linnakangas||Date: 2007-09-07 15:05:37|
|Subject: Re: Fwd: Caching driver on pgFoundry?|