Re: Practical Cursors - Mailing list pgsql-general

From Alex Pilosov
Subject Re: Practical Cursors
Date
Msg-id Pine.BSO.4.10.10109172300040.31711-100000@spider.pilosoft.com
Whole thread Raw
In response to Practical Cursors  ("Command Prompt, Inc." <pgsql-general@commandprompt.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: "Jeff Eckermann"
Date:
Subject: Re: Left Joins
Next
From: Sam Tregar
Date:
Subject: Re: Practical Cursors