Re: [SQL] sessions and prepared statements

2006-06-16 Thread PFC
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 st

Re: [SQL] sessions and prepared statements

2006-06-16 Thread Aaron Bono
If you are using pooled connections, doesn't PostgreSQL manage the prepared statements for you?  I would expect that, once I prepare a statement, if I attempt to do it again, PostgreSQL would say, "righty then, already done it, here you go".  Then again, I don't know what PostgreSQL does under the

Re: [SQL] sessions and prepared statements

2006-06-16 Thread Michael Fuhr
On Fri, Jun 16, 2006 at 08:55:16AM -0400, Rod Taylor wrote: > BEGIN; > SAVEPOINT; > SELECT * FROM temporary_prepared_statement; > ROLLBACK TO SAVEPOINT < on failure>; > CREATE TEMPORARY TABLE temporary_prepared_statement ...; > COMMIT; > > Now you have a place to store and retrieve prepared connec

Re: [SQL] sessions and prepared statements

2006-06-16 Thread Rod Taylor
On Fri, 2006-06-16 at 08:27 -0400, John DeSoi wrote: > 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? > >

Re: [SQL] sessions and prepared statements

2006-06-16 Thread John DeSoi
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 a

[SQL] sessions and prepared statements

2006-06-15 Thread chester c young
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 sess