Re: [HACKERS] Writeable CTEs Desgin Doc on Wiki

2010-08-17 Thread Robert Haas
On Mon, Aug 16, 2010 at 11:41 PM, Hitoshi Harada wrote: > 2010/8/17 Robert Haas : >> On Sun, Aug 15, 2010 at 7:44 AM, Hitoshi Harada wrote: >>> We (Marko, David Fetter and I) discussed on IRC about design of >>> writeable CTEs. It does and will contain not only syntax but also >>> miscellaneous s

Re: [HACKERS] Writeable CTEs Desgin Doc on Wiki

2010-08-17 Thread Marko Tiikkaja
On 2010-08-17 6:41 AM +0300, Hitoshi Harada wrote: 2010/8/17 Robert Haas: There are really two separate features here, and it might be worth giving them separate names and separate designs (and separate patches). Allowing the main query to be an insert, update, or delete seems easier than allow

Re: [HACKERS] Writeable CTEs Desgin Doc on Wiki

2010-08-16 Thread Hitoshi Harada
2010/8/17 Robert Haas : > On Sun, Aug 15, 2010 at 7:44 AM, Hitoshi Harada wrote: >> We (Marko, David Fetter and I) discussed on IRC about design of >> writeable CTEs. It does and will contain not only syntax but also >> miscellaneous specifications, general rules and restrictions. I hope >> this w

Re: [HACKERS] Writeable CTEs Desgin Doc on Wiki

2010-08-16 Thread Hitoshi Harada
2010/8/17 David Fetter : > On Mon, Aug 16, 2010 at 04:34:07PM -0400, Robert Haas wrote: >> On Mon, Aug 16, 2010 at 3:00 PM, David Fetter wrote: >> >> There has been previous talk of allowing WITH (COPY ...) and I am >> >> personally of the opinion that it would be nice to be able to do >> >> WITH

Re: [HACKERS] Writeable CTEs Desgin Doc on Wiki

2010-08-16 Thread Robert Haas
On Mon, Aug 16, 2010 at 5:08 PM, David Fetter wrote: > On Mon, Aug 16, 2010 at 04:34:07PM -0400, Robert Haas wrote: >> On Mon, Aug 16, 2010 at 3:00 PM, David Fetter wrote: >> >> There has been previous talk of allowing WITH (COPY ...) and I am >> >> personally of the opinion that it would be nice

Re: [HACKERS] Writeable CTEs Desgin Doc on Wiki

2010-08-16 Thread David Fetter
On Mon, Aug 16, 2010 at 04:34:07PM -0400, Robert Haas wrote: > On Mon, Aug 16, 2010 at 3:00 PM, David Fetter wrote: > >> There has been previous talk of allowing WITH (COPY ...) and I am > >> personally of the opinion that it would be nice to be able to do > >> WITH (EXPLAIN ...).  DDL seems like

Re: [HACKERS] Writeable CTEs Desgin Doc on Wiki

2010-08-16 Thread Robert Haas
On Mon, Aug 16, 2010 at 3:00 PM, David Fetter wrote: >> There has been previous talk of allowing WITH (COPY ...) and I am >> personally of the opinion that it would be nice to be able to do >> WITH (EXPLAIN ...).  DDL seems like a poor idea. > > It may be, but I can see use cases for partitioning.

Re: [HACKERS] Writeable CTEs Desgin Doc on Wiki

2010-08-16 Thread David Fetter
On Mon, Aug 16, 2010 at 02:25:50PM -0400, Robert Haas wrote: > On Sun, Aug 15, 2010 at 7:44 AM, Hitoshi Harada wrote: > > We (Marko, David Fetter and I) discussed on IRC about design of > > writeable CTEs. It does and will contain not only syntax but also > > miscellaneous specifications, general

Re: [HACKERS] Writeable CTEs Desgin Doc on Wiki

2010-08-16 Thread Robert Haas
On Sun, Aug 15, 2010 at 7:44 AM, Hitoshi Harada wrote: > We (Marko, David Fetter and I) discussed on IRC about design of > writeable CTEs. It does and will contain not only syntax but also > miscellaneous specifications, general rules and restrictions. I hope > this will help the patch reviews and

[HACKERS] Writeable CTEs Desgin Doc on Wiki

2010-08-15 Thread Hitoshi Harada
We (Marko, David Fetter and I) discussed on IRC about design of writeable CTEs. It does and will contain not only syntax but also miscellaneous specifications, general rules and restrictions. I hope this will help the patch reviews and stop dangerous design at the early stage. If you find something