David Fetter writes:
> On Sat, Jun 04, 2011 at 05:24:22PM -0400, Tom Lane wrote:
>> We could paste a copy of the original's cteList into the rule action,
>> but there are still issues:
>>
>> * If there's more than one rule action, we could end up executing
>> multiple copies of the same CTE query
On Sat, Jun 04, 2011 at 05:24:22PM -0400, Tom Lane wrote:
> Merlin Moncure writes:
> > On Fri, Jun 3, 2011 at 10:42 AM, Jehan-Guillaume (ioguix) de Rorthais
> > wrote:
> >> test=# CREATE RULE test_ins AS ON INSERT TO test DO INSTEAD INSERT INTO
> >> test2 VALUES (NEW.i);
> >> CREATE RULE
> >> tes
Merlin Moncure writes:
> On Fri, Jun 3, 2011 at 10:42 AM, Jehan-Guillaume (ioguix) de Rorthais
> wrote:
>> test=# CREATE RULE test_ins AS ON INSERT TO test DO INSTEAD INSERT INTO
>> test2 VALUES (NEW.i);
>> CREATE RULE
>> test=# WITH t1 AS (
>> DELETE FROM ONLY test RETURNING *
>> )
>> INSERT INT
On Fri, Jun 3, 2011 at 10:42 AM, Jehan-Guillaume (ioguix) de Rorthais
wrote:
>
> The following bug has been logged online:
>
> Bug reference: 6051
> Logged by: Jehan-Guillaume (ioguix) de Rorthais
> Email address: j...@dalibo.com
> PostgreSQL version: 9.1beta1
> Operating system
The following bug has been logged online:
Bug reference: 6051
Logged by: Jehan-Guillaume (ioguix) de Rorthais
Email address: j...@dalibo.com
PostgreSQL version: 9.1beta1
Operating system: Linux x86_64
Description:wCTE query fail with wrong error text on a table with
r