Re: Writeable CTEs and empty relations - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Writeable CTEs and empty relations
Date
Msg-id 910.1265670559@sss.pgh.pa.us
Whole thread Raw
In response to Writeable CTEs and empty relations  (Marko Tiikkaja <marko.tiikkaja@cs.helsinki.fi>)
Responses Re: Writeable CTEs and empty relations  (Marko Tiikkaja <marko.tiikkaja@cs.helsinki.fi>)
List pgsql-hackers
Marko Tiikkaja <marko.tiikkaja@cs.helsinki.fi> writes:
> I traced this down to heapam.c, which has this:
> ...
> This doesn't exactly work anymore since we modify the snapshot after
> calling ExecInitScan().

So don't do that.  The executor is generally entitled to assume that
parameters given to ExecutorStart are correct.  In particular, changing
the snapshot after the query has started to run seems to me to ensure
all sorts of inconsistent and undesirable behavior.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Re: [GENERAL] FM format modifier does not remove leading zero from year
Next
From: Jeff Davis
Date:
Subject: Re: Confusion over Python drivers