Rows created by a stored proc prompt Access' dreaded "write conflict"

From: Eric E <whalesuit(at)bonbon(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Rows created by a stored proc prompt Access' dreaded "write conflict"
Date: 2004-11-02 01:17:40
Message-ID: 4186E034.2090704@bonbon.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,
I am using an Access client linked to a PG 7.4 server via ODBC.

I have a stored proc on the server that inserts rows into a
table.particular table, accomplished via an INSERT
within the body of the stored proc. The procedure does not explicitly
commit this data, as no transactions are invoked.

The problem is that Access will not modify these records via table or
form view, giving its generic "Write conflict: another user has modified
this record" message. It does just fine for any other records in the
table, but it will not modify those created by the stored proc. It will
also execute an UPDATE OR DELETE query to modify these records This
stored procedure is pretty key for us to go forward.

Does anyone have any ideas of what's going on and how to fix it? I can
post more details, but I wanted to see if this was a known problem
before doing so.

Many thanks,

Eric

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John Fabiani 2004-11-02 01:34:21 Re: Calling on all SQL guru's
Previous Message Paul Tillotson 2004-11-02 00:50:06 Re: Numeric type problems