Search Postgresql Archives

Re: BEGIN strange behaviour

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, Nov 22, 2007 at 02:10:49PM +0100, luca.ciciriello@xxxxxxxx wrote:
> I've sperimented a strange behaviour using the command BEGIN and COMMIT in a
> multi-threaded Linux environment.
> In one of the two thread I use I've got the following message after
> PQexec(myconn, "BEGIN;");  

Uh, are your two threads using one connection?  That's never safe.

> The same commands (inside the same code) runs fine in Windows and in MacOS
> X.

If you're using one connection and two threads, this is some accident of the
client, and nothing more.

A

-- 
Andrew Sullivan
Old sigs will return after re-constitution of blue smoke

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux