Re: [BUGS] BUG #6051: wCTE query fail with wrong error text on a table with rules

2011-06-06 Thread Tom Lane
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

Re: [BUGS] BUG #6051: wCTE query fail with wrong error text on a table with rules

2011-06-06 Thread David Fetter
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

Re: [BUGS] BUG #6051: wCTE query fail with wrong error text on a table with rules

2011-06-04 Thread Tom Lane
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

Re: [BUGS] BUG #6051: wCTE query fail with wrong error text on a table with rules

2011-06-03 Thread Merlin Moncure
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

[BUGS] BUG #6051: wCTE query fail with wrong error text on a table with rules

2011-06-03 Thread Jehan-Guillaume (ioguix) de Rorthais
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