Re: [HACKERS] RQ: Prepared statements used by multiple connections - Mailing list pgsql-odbc

From Michael Fuhr
Subject Re: [HACKERS] RQ: Prepared statements used by multiple connections
Date
Msg-id 20050125214648.GB95908@winnie.fuhr.org
Whole thread Raw
In response to Re: [HACKERS] RQ: Prepared statements used by multiple connections  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-odbc
On Tue, Jan 25, 2005 at 10:36:34AM +0000, Christopher Kings-Lynne wrote:
> >
> >... a prepared version that is local to the backend that invokes the
> >function, yes (i.e. it will be planned once per backend). So ISTM this
> >is equivalent functionality to what you can get using PREPARE or the
> >extended query protocol.
>
> Are you sure it's only per-backend?  I thought I tested it and it seemed
> to prepare it everywhere... oh well.

How did you test it?  You can use settings like debug_print_plan
and client_min_messages to see what's happening in each backend.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-odbc by date:

Previous
From: George Weaver
Date:
Subject: Re: Error connecting a visual studio .NET "app" and PostgreSQL
Next
From: lothar.behrens@lollisoft.de
Date:
Subject: Re: ODBC (win32) X PostgreSQL(Linux)