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 [email protected]
Whole thread Raw
In response to Re: A little help with transactions, please  (Bruno Wolff III <[email protected]>)
List pgsql-novice
Bruno Wolff III <[email protected]> writes:
>   Richard Lough <[email protected]> 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