Re: postgres session termination

Поиск
Список
Период
Сортировка
От Ragnar Hafstað
Тема Re: postgres session termination
Дата
Msg-id 1107209325.27081.24.camel@localhost.localdomain
обсуждение исходный текст
Ответ на Re: postgres session termination  (Scott Marlowe <smarlowe@g2switchworks.com>)
Ответы Re: postgres session termination  (Scott Marlowe <smarlowe@g2switchworks.com>)
Список pgsql-general
On Mon, 2005-01-31 at 15:38 -0600, Scott Marlowe wrote:
> On Mon, 2005-01-31 at 09:28, Alban Hertroys wrote:
> > John DeSoi wrote:
> > > I think there are much better ways to do this. If the result set is
> > > large, the user could be waiting a very long time. Two possibilities are
> > > (1) use a cursor or (2) use limit and offset in your select statement
> > > grab only the rows you need to display.
> >
> > Someone correct me if I'm wrong, but I don't think PHP supports cursors
> > (Maybe PHP 5?).
> >
> > Otherwise, that would have been a neat solution indeed.
>
> PHP supports postgresql cursors, and has since php was able to connect
> to postgresql.

well, my impression was that the OP wanted to divide result sets
between web pages, so cursors would not help anyways,as they do
not survive their session.

gnari



В списке pgsql-general по дате отправления:

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: how to release a transaction lock on a table?
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: postgres session termination