Hello,
The following page says:
https://www.postgresql.org/docs/devel/static/ecpg-connect.html#ecpg-set-connection
--------------------------------------------------
EXEC SQL AT connection-name SELECT ...;
If your application uses multiple threads of execution, they cannot share a connection concurrently. You must either
explicitlycontrol access to the connection (using mutexes) or use a connection for each thread. If each thread uses its
ownconnection, you will need to use the AT clause to specify which connection the thread will use.
EXEC SQL SET CONNECTION connection-name;
...It is not thread-aware.
--------------------------------------------------
What does this mean by "not thread-aware?" Does SET CONNECTION in one thread change the current connection in another
thread?
It doesn't look so, because the connection management and SQL execution in ECPG uses thread-specific data (TSD) to get
andset the current connection, like this:
bool
ECPGsetconn(int lineno, const char *connection_name)
{ struct connection *con = ecpg_get_connection(connection_name);
if (!ecpg_init(con, connection_name, lineno)) return (false);
#ifdef ENABLE_THREAD_SAFETY pthread_setspecific(actual_connection_key, con);
#else actual_connection = con;
#endif return true;
}
Regards
Takayuki Tsunakawa