| From: | Marko Tiikkaja <marko(dot)tiikkaja(at)cs(dot)helsinki(dot)fi> |
|---|---|
| To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Writeable CTEs and empty relations |
| Date: | 2010-02-11 17:28:28 |
| Message-ID: | ca21d184f7fc2b3476e35b1e3e193ae5@cs.helsinki.fi |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, 11 Feb 2010 10:53:22 -0500, Robert Haas <robertmhaas(at)gmail(dot)com>
wrote:
> On Thu, Feb 11, 2010 at 8:46 AM, Marko Tiikkaja
> <marko(dot)tiikkaja(at)cs(dot)helsinki(dot)fi> wrote:
>> On 2010-02-11 03:44 +0200, I wrote:
>>> I'm going to have to disappoint a bunch of people and give up. :-(
>>
>> Btw. would it make sense to apply the WITH-on-top-of-DML part of this
>> patch? At least to me, this seems useful because you can write a
>> RECURSIVE SELECT and then use UPDATE .. FROM or DELETE .. USING on that
>> CTE.
>
> Hmm, that's a thought. Can you split out just that part?
Here's the patch. It's the same as the stuff in writeable CTE patches, but
I added regression tests.
Regards,
Marko Tiikkaja
| Attachment | Content-Type | Size |
|---|---|---|
| with_on_dml.patch | text/plain | 14.9 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Heikki Linnakangas | 2010-02-11 17:29:33 | Re: Re: [COMMITTERS] pgsql: Make standby server continuously retry restoring the next WAL |
| Previous Message | Joshua D. Drake | 2010-02-11 17:24:55 | Re: [HACKERS] Bug on pg_lesslog |