In-Reply-To: <20060615154930.44620.qmail@web54312.mail.yahoo.com>
References: <20060615154930.44620.qmail@web54312.mail.yahoo.com>
Mime-Version: 1.0 (Apple Message framework v750)
Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed
Message-Id: <4B156402-1B7D-46E2-8A4F-9DBD3F119CB7@pgedit.com>
Cc: pgsql-sql@postgresql.org
Content-Transfer-Encoding: 7bit
From: John DeSoi <desoi@pgedit.com>
Subject: Re: sessions and prepared statements
Date: Fri, 16 Jun 2006 08:27:37 -0400
To: chester c young <chestercyoung@yahoo.com>


On Jun 15, 2006, at 11:49 AM, chester c young wrote:

> in PHP for example, where there are multiple sessions and which you  
> get is random:
>
> how do you know if the session you're in has prepared a particular  
> statement?
>
> and/or how do you get a list of prepared statements?
>
> last, is there any after login trigger that one could use to  
> prepare statements the session would need? or is this a dumb idea?

If you are using pooled connections, I don't think there is a  
reasonable way you could managed prepared statements across requests.  
You'll probably want to just prepare the ones you need for the  
current request and discard them when the request ends.

I have a short article where you might find some useful information  
for managing prepared statements:

http://pgedit.com/resource/php/pgfuncall

You might also post your question to PostgreSQL PHP list -- probably  
more PHP expertise there.

Best,

John


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