Re: libpq CREATE DATABASE operation from multiple treads

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: p(dot)sun(dot)fun(at)gmail(dot)com
Cc: pgsql-sql(at)lists(dot)postgresql(dot)org
Subject: Re: libpq CREATE DATABASE operation from multiple treads
Date: 2020-10-08 20:32:28
Message-ID: 2624732.1602189148@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

p(dot)sun(dot)fun(at)gmail(dot)com writes:
> Thanks for the quick response. In the function that I execute in each
> thread, I create a new PGconn at the beginning. I expect that every
> function caller (thread) should use a unique PGconn. I would not expect
> that PGconn can be shared between threads. The documentation explicitly
> says that.

In that case you need to probe a little deeper. What error message(s)
are you getting? Is there anything relevant in the server's log?

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Rob Sargent 2020-10-08 20:35:16 Re: libpq CREATE DATABASE operation from multiple treads
Previous Message p.sun.fun 2020-10-08 20:30:27 Re: libpq CREATE DATABASE operation from multiple treads