Re: Review of Writeable CTE Patch - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Review of Writeable CTE Patch
Date
Msg-id 11096.1265212721@sss.pgh.pa.us
Whole thread Raw
In response to Re: Review of Writeable CTE Patch  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Review of Writeable CTE Patch
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> On Wed, Feb 3, 2010 at 4:09 AM, Marko Tiikkaja
> <marko.tiikkaja@cs.helsinki.fi> wrote:
>> We have yet to reach a consensus on the name for this feature. �I don't
>> think we have any really good candidates, but I like "DML WITH" best so far.

> Why can't we complain about the actual SQL statement the user issued?
> Like, say:
> INSERT requires RETURNING when used within a referenced CTE

We could probably make that work for error messages, but what about
documentation?  It's going to be awkward to write something like
"INSERT/UPDATE/DELETE RETURNING" every time we need to make a general
statement about the behavior of all three.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: rbtree test data
Next
From: Marko Tiikkaja
Date:
Subject: Re: Review of Writeable CTE Patch