Re: BEGIN strange behaviour - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: BEGIN strange behaviour
Date
Msg-id 20071122132825.GN21682@crankycanuck.ca
Whole thread Raw
In response to BEGIN strange behaviour  (luca.ciciriello@email.it)
List pgsql-general
On Thu, Nov 22, 2007 at 02:10:49PM +0100, luca.ciciriello@email.it 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

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: BEGIN strange behaviour
Next
From: "Francesco Esposito"
Date:
Subject: Re: BEGIN strange behaviour