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.
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 |