Postgres Pro
Downloads
Home   >   mailing lists

Difference between insert a tuple in a table by function and by datasheet - Mailing list pgsql-odbc

From DI Hasenöhrl
Subject Difference between insert a tuple in a table by function and by datasheet
Date
Msg-id 001e01c0faec$352f6be0$01011eac@irina
Whole thread Raw
Responses RE: Difference between insert a tuple in a table by function and by datasheet
Re: Difference between insert a tuple in a table by function and by datasheet
List pgsql-odbc
Tree view
Hi,
 
this is my 2nd attempt to get some links for my problem.
I don't know whether my question is so stupid or difficult or I'm in the wrong list. Please let me know.
 
I have the following situation: ( I use MsAccess97 as frontend, ODBC 7.1.0003)
I insert tuples in a table with a plpgsql-function, called in a form via VBA-code. It works fine, but I can't update these tuples in datasheet view. ERROR: an other user has changed in the meantime.....but I'm the only.
When I insert tuples via datasheet view, I can update these tuples, but only these.
 
I can't see a difference between the tuples inserted by the function and datasheet, but it looks like, that the tuples are *marked*.
 
Please, give me some information to solve my problem.
 
Thanks
Irina
 

pgsql-odbc by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: slow performance postgres 7.0.3 and odbc
Next
From: "Hiroshi Inoue"
Date:
Subject: RE: Difference between insert a tuple in a table by function and by datasheet