Re: COPY with no WAL, in certain circumstances

On Sun, 2007-01-07 at 03:53 -0500, Tom Lane wrote:
> "Simon Riggs" <simon@2ndquadrant.com> writes:
> > On Sat, 2007-01-06 at 21:18 -0500, Tom Lane wrote:
> >> Uh ... what in the world has an active portal got to do with it?
> >> I think you've confused snapshot considerations with crash recovery.
>
> > The patch sets HEAP_XMIN_COMMITTED on all of the rows loaded by COPY as
> > well.
>
> I think you just talked yourself out of getting this patch applied.

Maybe; what would be your explanation? Do you have a failure case you
know of? Perhaps if one exists, there is another route.

--
  Simon Riggs
  EnterpriseDB   http://www.enterprisedb.com