Bruno Wolff III <bruno(at)wolff(dot)to> writes:
> Richard Lough <ralough(dot)ced(at)dnet(dot)co(dot)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