Re: A little help with transactions, please - Mailing list pgsql-novice

From Tom Lane
Subject Re: A little help with transactions, please
Date
Msg-id 8192.1071087629@sss.pgh.pa.us
Whole thread Raw
In response to Re: A little help with transactions, please  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-novice
Bruno Wolff III <bruno@wolff.to> writes:
>   Richard Lough <ralough.ced@dnet.co.uk> wrote:
>> I find that the update to table A attempts to produce a duplicate
>> primary primary key, and synchronisation with the server is lost.

> I don't think it is normal for failed update statements to cause loss
> of synchronization with the server.

It is not.  And if that is what is happening, how does the second update
"proceed" at all?  I suspect client-side programming error, but there's
not enough info here to diagnose it.

            regards, tom lane

pgsql-novice by date:

Previous
From: "R. Kelly"
Date:
Subject: Re: relationship/table design question
Next
From: Stephan Szabo
Date:
Subject: Re: [GENERAL] PostgreSQL Training