Re: Writeable CTEs and empty relations

From: Marko Tiikkaja <marko(dot)tiikkaja(at)cs(dot)helsinki(dot)fi>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Writeable CTEs and empty relations
Date: 2010-02-10 00:25:19
Message-ID: 4B71FCEF.8040208@cs.helsinki.fi
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2010-02-10 02:19 +0200, Tom Lane wrote:
> Marko Tiikkaja <marko(dot)tiikkaja(at)cs(dot)helsinki(dot)fi> writes:
>> Does this sound completely unacceptable?
>
> You still haven't explained why it's a good idea to change the snapshot
> after the executor has started. Right at the moment I'm prepared to
> reject the patch on that ground alone.

The patch only touches the snapshot's curcid. That's needed to allow
the queries see the tuples of the DML WITHs ran before that particular
query.

Regards,
Marko Tiikkaja

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeff Davis 2010-02-10 00:30:35 Re: Listen / Notify - what to do when the queue is full
Previous Message Tom Lane 2010-02-10 00:19:56 Re: Writeable CTEs and empty relations