Skip site navigation (1) Skip section navigation (2)

Re: patch to create system view that lists cursors

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Neil Conway <neilc(at)samurai(dot)com>
Cc: Joachim Wieland <joe(at)mcknight(dot)de>, pgsql-patches(at)postgresql(dot)org
Subject: Re: patch to create system view that lists cursors
Date: 2006-01-13 00:51:58
Message-ID: 19897.1137113518@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-patches
Neil Conway <neilc(at)samurai(dot)com> writes:
> Why list Portals that cannot be directly manipulated by the user?

Define "directly manipulated".  AFAIR there isn't any particular
distinction between portals that got made by DECLARE CURSOR and those
that got made by Bind; you can use either EXECUTE or Fetch for either.
Also, a portal that has gone into ERROR state should still be listed,
IMHO, because the behavior the user will expect is that it's there until
he CLOSEs it.

> It would also mean that this would produce unexpected results:
> "PREPARE foo AS SELECT * FROM pg_cursors; EXECUTE foo".

Unexpected in what sense?

			regards, tom lane

In response to

Responses

pgsql-patches by date

Next:From: Christopher Kings-LynneDate: 2006-01-13 02:02:35
Subject: Re: patch to create system view that lists cursors
Previous:From: Neil ConwayDate: 2006-01-13 00:39:54
Subject: Re: patch to create system view that lists cursors

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group