Re: Commits 8de72b and 5457a1 (COPY FREEZE) - Mailing list pgsql-hackers

From Noah Misch
Subject Re: Commits 8de72b and 5457a1 (COPY FREEZE)
Date
Msg-id 20121211033040.GC32120@tornado.leadboat.com
Whole thread Raw
In response to Re: Commits 8de72b and 5457a1 (COPY FREEZE)  (Stephen Frost <sfrost@snowman.net>)
List pgsql-hackers
On Mon, Dec 10, 2012 at 08:54:04PM -0500, Stephen Frost wrote:
> I agree that it's unlikely that
> applications are depending on today's behavior of TRUNCATE making
> concurrent transactions see an empty table, but it does *not* follow
> that applications *won't* start depending on this new behavior of COPY
> FREEZE.

That is a good point.  I'm not sure whether that should worry us enough to
implement an error in the scenario before letting COPY write frozen tuples.
But it's the strongest argument I've seen for imposing that prerequisite.

> Even if we could fix that, I'd be against allowing it arbitrairly for
> any regular user INSERT or UPDATE; I'm still not particularly happy with
> this approach for COPY.

Sure; COPY is the 99% important case here.



pgsql-hackers by date:

Previous
From: "Karl O. Pinc"
Date:
Subject: Re: Multiple --table options for other commands
Next
From: Bruce Momjian
Date:
Subject: Re: [PATCH] pg_upgrade -o/-O regression in 9.2.2