Postgres Pro
Downloads
Home   >   mailing lists

Re: MS Access 2007 update write conflict problem & resolution - Mailing list pgsql-general

From Craig Ringer
Subject Re: MS Access 2007 update write conflict problem & resolution
Date
Msg-id 4BA448C2.1000503@postnewspapers.com.au
Whole thread Raw
In response to MS Access 2007 update write conflict problem & resolution  ("Little, Douglas" <DOUGLAS.LITTLE@orbitz.com>)
List pgsql-general
Tree view 
On 19/03/2010 11:35 PM, Little, Douglas wrote:

> The update can’t then locate the row (timestamp mismatch), and displays
> the ‘write conflict’ error.

Change the ODBC driver settings to issue updates by primary key, and the
issue goes away. IIRC it's done in some backward-ish way like turning
off "row versioning".

--
Craig Ringer

pgsql-general by date:

Previous
From: zhong ming wu
Date:
Subject: returns 0 row from plpgsql function
Next
From: Pavel Stehule
Date:
Subject: Re: returns 0 row from plpgsql function