Re: Cursors and Transactions, why? - Mailing list pgsql-general

From Joe Conway
Subject Re: Cursors and Transactions, why?
Date
Msg-id 4074934A.2010408@joeconway.com
Whole thread Raw
In response to Re: Cursors and Transactions, why?  (Eric Ridge <ebr@tcdi.com>)
Responses Re: Cursors and Transactions, why?
List pgsql-general
Eric Ridge wrote:
> Is the tuplestore basically just an array of ItemPointer-s?  In mean,
> it's not a copy of each entire row, is it?

Yup, it is copied:

src/backend/utils/sort/tuplestore.c:tuplestore_puttuple()
8<--------------------------------------------------------
/*
  * Accept one tuple and append it to the tuplestore.
  *
  * Note that the input tuple is always copied; the caller need not save
  * it.
8<--------------------------------------------------------

Joe


pgsql-general by date:

Previous
From: Kevin Lohka
Date:
Subject: Re: Are functions automatically transactioned?
Next
From: Eric Ridge
Date:
Subject: Re: Cursors and Transactions, why?