Postgres Pro
Downloads
Home   >   mailing lists

Re: [NOVICE] Executing prepared statements in the multithreaded envs - Mailing list pgsql-novice

From David G. Johnston
Subject Re: [NOVICE] Executing prepared statements in the multithreaded envs
Date
Msg-id CAKFQuwaxNLYndO6Wcppj-3pNuHSeCuJf8WjRMLWNqruq52DqPA@mail.gmail.com
Whole thread Raw
In response to [NOVICE] Executing prepared statements in the multithreaded envs  (Ruslan R. Laishev <zator@yandex.ru>)
Responses Re: [NOVICE] Executing prepared statements in the multithreaded envs
List pgsql-novice
Tree view
On Tue, Oct 17, 2017 at 7:00 AM, Ruslan R. Laishev <zator@yandex.ru> wrote:
Hi All!
 
I'd like to use a pool of connections in multi-threaded environment, so:
 
1. I created a pool of N-connection by calling PQconnectdb().
2. Do I'm need to calling PQprepare() for the every sql_query for the every connection from the pool ?
 

​Named prepared statements are session-local information.  When you first start a new session there are none.  The ones you create remain until you either disconnect the session or "RESET" the session.

David J.

pgsql-novice by date:

Previous
From: Ruslan R. Laishev
Date:
Subject: [NOVICE] Executing prepared statements in the multithreaded envs
Next
From: Ruslan R. Laishev
Date:
Subject: Re: [NOVICE] Executing prepared statements in the multithreaded envs