Re: ECPG and multiple threads

> I'm porting an embedded-SQL application to PostgreSQL so embedded sql
> is a must for me. My application is multi-threaded. SQL queries are
> used by several threads. The program keeps terminating unexpectedly in
> deemingly "innocent" places.
> I figured out that ecpg library can be responsible for this.
> Here:
> http://www.postgresql.org/docs/8.1/interactive/ecpg-process.html
> I found the information that:
> "The ecpg library is thread-safe if it is built using the
> --enable-thread-safety command-line option to configure."
> However my instance of PostgreSQL was installed from _binaries_ that I
> downloaded from http://www.postgresql.org
>
> The questions:
> 1. How do I know how my copy of libecpg.lib was built and if it is
> thread-safe?
> 2. Is there a place I could get the thread-safe version of this
> library if I don't want to get into building the whole stuff from the
> source code?

1. You can call 'pg_config' in the bin directory,
it will tell you the build flags.

2. You did not mention the operating system you use.

Yours,
Laurenz Albe