Re: pgpool simple feature request - Mailing list pgsql-general

From Tatsuo Ishii
Subject Re: pgpool simple feature request
Date
Msg-id 20050209.153156.51836943.t-ishii@sra.co.jp
Whole thread Raw
In response to Re: pgpool simple feature request  (Vivek Khera <khera@yertle.int.kciLink.com>)
List pgsql-general
> >>>>> "TI" == Tatsuo Ishii <t-ishii@sra.co.jp> writes:
>
> TI> Yes, I thought about that too. Probably we need two kinds of
> TI> initializations:
>
> TI> 1) initilization for each new connection (as you requested)
>
> TI> 2) initilization for each new client connection
>
> I think this latter one is important.  Take the case where I do some
> "set FOO BAR" values to alter the query (eg, statement timeout or
> sequence scan disable) which should be reset on new client connection
> when it re-uses a backend connection.
>
> Or is this magically handled already?

Yes. pgpool issues "RESET ALL" at the end of each client
connection. See "reset_query_list" directive.
--
Tatsuo Ishii

pgsql-general by date:

Previous
From: John DeSoi
Date:
Subject: Re: Database permissions
Next
From: John DeSoi
Date:
Subject: Re: Postgresql and Macintosh