Re: How do I use the backend APIs

From: "Chad" <chadzakary(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How do I use the backend APIs
Date: 2006-02-21 10:41:13
Message-ID: 1140518473.707045.12870@z14g2000cwz.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks Martijn/Alban,

This look interesting. I'll make some time to try this problem out
using your approach.
I have a few questions like:
-Could I skip the FETCH FORWARD and go straight to the FETCH BACKWARD
i.e. declare cursor to be at "Mal" and go backwards from there or is
the cursor limited to going backward only as far as "Mal"?
-Does the DB avoid transferring the data until the FETCH command?
-When rows change in between opening the cursor and fetching the
changed rows, will the FETCH retrieve the new data or is a snapshot
taken when the cursor is declared ?
-What about concurrency? If a cursor is kept open while other
transactions change the same table or does it cause those writer
transactions to block? Perhaps this is configurable.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message uuZZuuZZ (sent by Nabble.com) 2006-02-21 14:39:13 win cmd line query tool
Previous Message Martijn van Oosterhout 2006-02-21 06:44:07 Re: Mixing different LC_COLLATE and database encodings