Re: Practical Cursors

On Mon, 17 Sep 2001, Command Prompt, Inc. wrote:

> However, using something like PHP will not allow this because HTTP is
> stateless and PostgreSQL will not know from one transaction to the next
> that the results of the connection are related.
> 
> Is this truly the case, or is there a way for PostgreSQL to remember the
> connection identifier so that the next time a PHP connection is made with
> the same identifier a transaction can be completed?
Not currently. Cursor right now is a per-backend thing. A lot of changes
are needed to make cursors global. (particularly transaction-awareness)

-alex