Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group