Re: postgres session termination

On Jan 30, 2005, at 9:24 PM, Rick Schumeyer wrote:

> I’m accessing this via a php web page.  I’m thinking that maybe
>
> the best way to do this, other than re-running the query each time,
>
> is to put the results into a temporary table.  I think this will work
>
> if I never call “disconnect” from the php script.  My question is,
>
> when does my Postgres session end?  Is there a timeout?
>
>  
>
> Of course, if this is a really bad way to do this, I’m willing to
>
> learn a better way!

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.

I think phpPgAdmin (http://phppgadmin.sourceforge.net/) uses option 2.
You could download the source and see how they implement the table
browser.

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL