Re: Postgres 7.4 : ECPG not Thread-safe

Thierry Missimilly wrote:
> Please enter a FULL description of your problem:
> ------------------------------------------------
> I think i have a Thread-safe problem. PostgreSQL developpers will find a
> test program to reproduce it on their lab.
>
> I have, already sent this to pgsql-general and pgsql-hacker, but get
> back not answers. But neve mind.
>
> I've built Postgresql with the option --enable-thread-safety --with-tcl.
>
> And now run a pgbench like program call pgbch.pgc (attached with this
> mail).
>
> The main differences of pgbch.pgc are :
> 1) Pro*c code
> 2) Multi-threaded
> 3) Some specific code for Oracle
> 4) Some specific dynamic trace for debug
>

I have worked with this user and found they were using EXEC SQL from
different threads, but were not using the "AT" clause to force the
threads to use their own private connection, so there was no threading
bug in our code.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073