Re: Cursor names

Поиск
Список
Период
Сортировка
Искать

Re: Cursor names

От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
Nathaniel Trellice  writes:
> So my question is: what are the constraints on ? Must each cursor name be unique amongst all declared cursors from all clients, or just unique within a single connection from a single client, or something else?

Cursor names are local to a session.

			regards, tom lane

Cursor names

От:
Nathaniel Trellice <naptrel@yahoo.co.uk>
Дата:
Hi all,

I'm using a cursor to read query results a few rows at a time. The syntax I'm using to 'create' the cursor is:

  DECLARE  BINARY CURSOR FOR SELECT [rest of query];

followed by calls to

  FETCH FORWARD  FROM 

and everything's working nicely.

My DB has multiple clients each of which may have multiple connections open the the DB (the client app is threaded), all making cursored queries simultaneously.

So my question is: what are the constraints on ? Must each cursor name be unique amongst all declared cursors from all clients, or just unique within a single connection from a single client, or something else?

Nathaniel
FAQ