From i.hasenoehrl@aon.at Fri Jun 22 07:23:02 2001 Received: from email02.aon.at (WARSL401PIP3.highway.telekom.at [195.3.96.75]) by postgresql.org (8.11.3/8.11.1) with SMTP id f5M7Mva05473 for ; Fri, 22 Jun 2001 03:23:02 -0400 (EDT) (envelope-from i.hasenoehrl@aon.at) Received: (qmail 237844 invoked from network); 22 Jun 2001 07:22:53 -0000 Received: from n654p020.adsl.highway.telekom.at (HELO irina) ([62.47.25.180]) (envelope-sender ) by qmail2.highway.telekom.at (qmail-ldap-1.03) with SMTP for ; 22 Jun 2001 07:22:53 -0000 Message-ID: <001e01c0faec$352f6be0$01011eac@irina> From: =?iso-8859-1?Q?DI_Hasen=F6hrl?= To: , Subject: Difference between insert a tuple in a table by function and by datasheet Date: Fri, 22 Jun 2001 09:23:17 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_001B_01C0FAFC.F86D7740" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 X-Archive-Number: 200106/88 X-Sequence-Number: 644 This is a multi-part message in MIME format. ------=_NextPart_000_001B_01C0FAFC.F86D7740 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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 wr= ong list. Please let me know. I have the following situation: ( I use MsAccess97 as frontend, ODBC 7.1.00= 03) I insert tuples in a table with a plpgsql-function, called in a form via VB= A-code. It works fine, but I can't update these tuples in datasheet view. E= RROR: 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 onl= y these. I can't see a difference between the tuples inserted by the function and da= tasheet, but it looks like, that the tuples are *marked*. Please, give me some information to solve my problem. Thanks Irina E-Mail: i.hasenoehrl@aon.at ------=_NextPart_000_001B_01C0FAFC.F86D7740 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi,
 
this is my 2nd attempt to get some links f= or my=20 problem.
I don't know whether my question is so stu= pid or=20 difficult or I'm in the wrong list. Please let me know.
 
I have the following situation: ( I use Ms= Access97=20 as frontend, ODBC 7.1.0003)
I insert tuples in a table with a plpgsql-= function,=20 called in a form via VBA-code. It works fine, but I can't update these tupl= es in=20 datasheet view. ERROR: an other user has changed in the meantime.....but I'= m the=20 only.
When I insert tuples via datasheet view, I= can=20 update these tuples, but only these.
 
I can't see a difference between the tuple= s=20 inserted by the function and datasheet, but it looks like, that the tuples = are=20 *marked*.
 
Please, give me some information to solve = my=20 problem.
 
Thanks
Irina
 
E-Mail: i.hasenoehrl@aon.at
------=_NextPart_000_001B_01C0FAFC.F86D7740-- From cslucki@cyberworkers.com Fri Jun 22 12:44:52 2001 Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f5MCiqa51850 for ; Fri, 22 Jun 2001 08:44:52 -0400 (EDT) (envelope-from pgsql-sql-owner@postgresql.org) Received: from host0.xcom.fr (host0.xcom.fr [213.215.14.219]) by postgresql.org (8.11.3/8.11.1) with SMTP id f5M86ba36248 for ; Fri, 22 Jun 2001 04:06:38 -0400 (EDT) (envelope-from cslucki@cyberworkers.com) Received: (qmail 23828 invoked from network); 22 Jun 2001 04:51:26 -0000 Received: from proxy.xcom.fr (HELO pccyril) (213.215.14.233) by host0.xcom.fr with SMTP; 22 Jun 2001 04:51:26 -0000 Reply-To: From: "Cyril Slucki" To: Subject: RE: Difference between insert a tuple in a table by function and by datasheet Date: Fri, 22 Jun 2001 10:02:36 +0200 Message-ID: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0045_01C0FB02.768555D0" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) X-MimeOLE: Produced By Microsoft MimeOLE V5.00.3018.1300 In-Reply-To: <001e01c0faec$352f6be0$01011eac@irina> Importance: Normal X-Archive-Number: 200106/363 X-Sequence-Number: 3650 C'est un message de format MIME en plusieurs parties. ------=_NextPart_000_0045_01C0FB02.768555D0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit REMOVE -----Message d'origine----- De : pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]De la part de DI Hasenöhrl Envoyé : vendredi 22 juin 2001 09:23 À : pgsql-sql@postgresql.org; pgsql-odbc@postgresql.org Objet : [SQL] Difference between insert a tuple in a table by function and by datasheet 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 E-Mail: i.hasenoehrl@aon.at ---------------------------------------------------------------------------- -- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (www.grisoft.com). Version: 6.0.262 / Virus Database: 132 - Release Date: 12/06/2001 ------=_NextPart_000_0045_01C0FB02.768555D0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
REMOVE
-----Message d'origine-----
De :=20 pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]= De la=20 part de DI Hasen=F6hrl
Envoy=E9 : vendredi 22 juin 200= 1=20 09:23
=C0 : pgsql-sql@postgresql.org;=20 pgsql-odbc@postgresql.org
Objet : [SQL] Difference between= =20 insert a tuple in a table by function and by datasheet

Hi,
 
this is my 2nd attempt to get some links= for my=20 problem.
I don't know whether my question is so s= tupid or=20 difficult or I'm in the wrong list. Please let me know.
 
I have the following situation: ( I use= =20 MsAccess97 as frontend, ODBC 7.1.0003)
I insert tuples in a table with a=20 plpgsql-function, called in a form via VBA-code. It works fine, but I can= 't=20 update these tuples in datasheet view. ERROR: an other user has changed i= n the=20 meantime.....but I'm the only.
When I insert tuples via datasheet view,= I can=20 update these tuples, but only these.
 
I can't see a difference between the tup= les=20 inserted by the function and datasheet, but it looks like, that the tuple= s are=20 *marked*.
 
Please, give me some information to solv= e my=20 problem.
 
Thanks
Irina
 
E-Mail: i.hasenoehrl@aon.at


Incoming mail is certified Virus Free.
Che= cked by=20 AVG anti-virus system (www.grisoft.com= ).=20
Version: 6.0.262 / Virus Database: 132 - Release Date:=20 12/06/2001


Outgoing mail is certified Virus Free.=
Checked by AVG anti-virus system (www.gr= isoft.com).
Version: 6.0.262 / Virus Database: 132 - Release Date: 12/06/2001

------=_NextPart_000_0045_01C0FB02.768555D0-- From Inoue@tpf.co.jp Fri Jun 22 08:16:42 2001 Received: from sd.tpf.co.jp (sd.tpf.co.jp [210.161.239.34]) by postgresql.org (8.11.3/8.11.1) with SMTP id f5M8Gfa40965 for ; Fri, 22 Jun 2001 04:16:42 -0400 (EDT) (envelope-from Inoue@tpf.co.jp) Received: (qmail 4497 invoked from network); 22 Jun 2001 08:16:36 -0000 Received: from unknown (HELO mcadnote1) (126.0.1.68) by sd2.tpf-fw-c.co.jp with SMTP; 22 Jun 2001 08:16:36 -0000 From: "Hiroshi Inoue" To: "DI Hasen?rl" Cc: , Subject: RE: Difference between insert a tuple in a table by function and by datasheet Date: Fri, 22 Jun 2001 17:17:45 +0900 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 Importance: Normal In-Reply-To: <001e01c0faec$352f6be0$01011eac@irina> X-Archive-Number: 200106/89 X-Sequence-Number: 645 -----Original Message----- From: DI Hasenöhrl > 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. Don't your table have float columns ? regards, Hiroshi Inoue From dariush@ajax.umcs.lublin.pl Fri Jun 22 08:25:09 2001 Received: from ajax.umcs.lublin.pl (ajax.umcs.lublin.pl [212.182.58.82]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5M8P9a45076 for ; Fri, 22 Jun 2001 04:25:09 -0400 (EDT) (envelope-from dariush@ajax.umcs.lublin.pl) Received: from localhost (user: 'dariush', uid#550) by ajax.umcs.lublin.pl with ESMTP id ; Fri, 22 Jun 2001 10:25:30 +0200 Date: Fri, 22 Jun 2001 10:25:30 +0200 (CEST) From: Dariusz Pietrzak To: =?iso-8859-1?Q?DI_Hasen=F6hrl?= cc: pgsql-odbc@postgresql.org Subject: Re: Difference between insert a tuple in a table by function and by datasheet In-Reply-To: <001e01c0faec$352f6be0$01011eac@irina> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200106/92 X-Sequence-Number: 648 > 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. Answer to that is actually in a FAQ. Try setting 'row versioning' in your ODBC source, and remember to overload '=' operator for int4 and xid. You'll find implementation in the FAQ. Oh, and maybe someone knows - when in access I do 'refresh linked tables' it's very very slow, and doesen't work the way I want ( ie - when I changed say 'row versioning' in driver acces won't notice until I delete and re-add linked tables). -- Dariusz Pietrzak Certified Nobody From dev@archonet.com Fri Jun 22 16:33:12 2001 Received: from anchor-post-30.mail.demon.net (anchor-post-30.mail.demon.net [194.217.242.88]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5MGXCa68988 for ; Fri, 22 Jun 2001 12:33:12 -0400 (EDT) (envelope-from dev@archonet.com) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-30.mail.demon.net with esmtp (Exim 2.12 #1) id 15DTu4-000GGi-0U; Fri, 22 Jun 2001 17:35:28 +0100 Received: from client (client.archonet.com [192.168.1.16]) by mainbox.archonet.com (Postfix) with SMTP id 343D813E33; Fri, 22 Jun 2001 17:08:33 +0100 (BST) Message-ID: <003201c0fb35$956d9880$1001a8c0@archonet.com> From: "Richard Huxton" To: , References: Subject: Re: Difference between insert a tuple in a table by function and by datasheet Date: Fri, 22 Jun 2001 17:08:25 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200106/379 X-Sequence-Number: 3671 From: "Cyril Slucki" > 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. You might try the pgsql-odbc or pgsql-interfaces lists - it's also worth checking the archives for similar issues. I think the reason you've had no success here is we're all waiting for someone with an answer to pipe up. > 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. Well - I can think out loud FWIW. Access thinks something has changed the values, so there are a couple of things you can try: 1. Are you experiencing any timezone/clock-related problems elsewhere? 2. If you insert tuples then quit and restart Access can you edit them at that time? 3. Can you edit all tuples from psql? 4. If you write a pass-through query to update tuples does that work? 5. If you write a function to update tuples does that work? If it's any use here are the ODBC settings I use: Database, Server, User Name, Password - set as required Port: 5432 On the Advanced Options (Driver) dialogue... Disable Genetic Optimiser: Y KSQO: Y Recognize Unique Indexes: Y Use Declare/Fetch: N CommLog: N ReadOnly: N Parse Statements: N Cancel as FreeStmt: N Unknown Sizes: Maximum Text as LongVarChar: Y Unknowns as LongVarChar: N Bools as Char: Y Cache size: 100 Max Varchar: 1024 Max LongVarChar: 8190 Systable prefix: pg_; Connect Settings: (blank) Advanced Options (Postgresql) dialogue Protocol: 7.X,6.4 all other items unticked/blank. HTH - Richard Huxton From i.hasenoehrl@aon.at Mon Jun 25 10:26:30 2001 Received: from email04.aon.at (WARSL401PIP7.highway.telekom.at [195.3.96.115]) by postgresql.org (8.11.3/8.11.1) with SMTP id f5PAQUa42330 for ; Mon, 25 Jun 2001 06:26:30 -0400 (EDT) (envelope-from i.hasenoehrl@aon.at) Received: (qmail 293446 invoked from network); 25 Jun 2001 10:26:17 -0000 Received: from n654p020.adsl.highway.telekom.at (HELO irina) ([62.47.25.180]) (envelope-sender ) by qmail4.highway.telekom.at (qmail-ldap-1.03) with SMTP for ; 25 Jun 2001 10:26:17 -0000 Message-ID: <005901c0fd61$51c69e00$01011eac@irina> From: =?iso-8859-1?Q?DI_Hasen=F6hrl?= To: "Richard Huxton" Cc: , References: <003201c0fb35$956d9880$1001a8c0@archonet.com> Subject: Re: [SQL] Difference between insert a tuple in a table by function and by datasheet Date: Mon, 25 Jun 2001 12:26:38 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0056_01C0FD72.14F3E080" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 X-Archive-Number: 200106/99 X-Sequence-Number: 655 This is a multi-part message in MIME format. ------=_NextPart_000_0056_01C0FD72.14F3E080 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Thank you for your information! ----- Original Message -----=20 From: Richard Huxton=20 To: cslucki@cyberworkers.com ; pgsql-sql@postgresql.org=20 Sent: Friday, June 22, 2001 6:08 PM Subject: Re: [SQL] Difference between insert a tuple in a table by functi= on and by datasheet From: "Cyril Slucki" > 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. You might try the pgsql-odbc or pgsql-interfaces lists - it's also worth checking the archives for similar issues. I think the reason you've had no success here is we're all waiting for someone with an answer to pipe up. I put it in the pgsql-odbc list too > 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, b= ut > 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. Well - I can think out loud FWIW. Access thinks something has changed the values, so there are a couple of things you can try: 1. Are you experiencing any timezone/clock-related problems elsewhere? no 2. If you insert tuples then quit and restart Access can you edit them at that time? no 3. Can you edit all tuples from psql? yes 4. If you write a pass-through query to update tuples does that work? yes 5. If you write a function to update tuples does that work? yes If it's any use here are the ODBC settings I use: Database, Server, User Name, Password - set as required Port: 5432 On the Advanced Options (Driver) dialogue... Disable Genetic Optimiser: Y KSQO: Y Recognize Unique Indexes: Y Use Declare/Fetch: N CommLog: N ReadOnly: N Parse Statements: N Cancel as FreeStmt: N Unknown Sizes: Maximum Text as LongVarChar: Y Unknowns as LongVarChar: N Bools as Char: Y Cache size: 100 Max Varchar: 1024 Max LongVarChar: 8190 Systable prefix: pg_; Connect Settings: (blank) Advanced Options (Postgresql) dialogue Protocol: 7.X,6.4 all other items unticked/blank. I use the same settings Now, I have located the problem, but I can't solve it. In my function, I make the following calculation: ............... update KalkPreislisten_float8 SET kp_ep =3D rkontingent.k_ep::float8= -- this works correct but I have to calculate with a numeric type too (rwaehrung.w_euro is nume= ric(9,5)) .................... update KalkPreislisten_float8 SET kp_ep =3D rkontingent.k_ep::float8 *rw= aehrung.w_euro::float8 -- this doesn't work I discovered, that a calculation float * float causes, that I can't updat= e tuples in datasheet view. float * integer works correct What I'm doing wrong????? Please, let me know, how to realize calculations with type: float * float Thanks in advance Irina ------=_NextPart_000_0056_01C0FD72.14F3E080 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Thank you for your=20 information!
----- Original Message -----
Fro= m:=20 Richard Huxt= on=20
To: cslucki@cyberworkers.com ; pgsql-sql@postgresql.org
Sent: Friday, June 22, 2001 6:08 P= M
Subject: Re: [SQL] Difference betw= een=20 insert a tuple in a table by function and by datasheet

From: "Cyril Slucki" <cslucki@cyberworkers.com>=

>  =20 this is my 2nd attempt to get some links for my problem.
> &nb= sp; I=20 don't know whether my question is so stupid or difficult or I'm in the>=20 wrong list. Please let me know.

You might try the pgsql-odbc or=20 pgsql-interfaces lists - it's also worth
checking the archives for sim= ilar=20 issues. I think the reason you've had no
success here is we're all wai= ting=20 for someone with an answer to pipe up.
I put it in the pgsql-od= bc list=20 too

>   I have the following situation: ( I use MsAcces= s97=20 as frontend, ODBC
> 7.1.0003)
>   I insert tuples i= n a=20 table with a plpgsql-function, called in a form via
> VBA-code. It = works=20 fine, but I can't update these tuples in datasheet
view.
> ERROR= : an=20 other user has changed in the meantime.....but I'm the=20 only.
>   When I insert tuples via datasheet view, I can= =20 update these tuples, but
> only these.
>
>   = I=20 can't see a difference between the tuples inserted by the function and>=20 datasheet, but it looks like, that the tuples are=20 *marked*.
>
>   Please, give me some information to= =20 solve my problem.

Well - I can think out loud FWIW.

Access= =20 thinks something has changed the values, so there are a couple of
thin= gs=20 you can try:

1. Are you experiencing any timezone/clock-related=20 problems elsewhere?
no
2. If you insert tuples then quit= and=20 restart Access can you edit them at
that time?
no
3. Can you edit all tuples from= =20 psql?
yes
4. If you write a pass-through q= uery to=20 update tuples does that work?
yes
5. If you write a function to up= date=20 tuples does that work?
yes

If it's any use here are the= ODBC=20 settings I use:

Database, Server, User Name, Password - set as=20 required
Port: 5432

On the Advanced Options (Driver)=20 dialogue...
Disable Genetic Optimiser: Y
KSQO: Y
Recognize Uniqu= e=20 Indexes: Y
Use Declare/Fetch: N
CommLog: N
ReadOnly: N
Parse= =20 Statements: N
Cancel as FreeStmt: N
Unknown Sizes: Maximum
Text = as=20 LongVarChar: Y
Unknowns as LongVarChar: N
Bools as Char: Y
Cache= =20 size: 100
Max Varchar: 1024
Max LongVarChar: 8190
Systable prefi= x:=20 pg_;
Connect Settings: (blank)

Advanced Options (Postgresql)=20 dialogue
Protocol: 7.X,6.4
all other items unticked/blank.
I use the same=20 settings
 
Now, I have located the = problem,=20 but I can't solve it.
In my function, I make t= he=20 following calculation:
    ...............
    updat= e=20 KalkPreislisten_float8 SET  kp_ep =3D=20 rkontingent.k_ep::float8        -- thi= s=20 works correct
 
but I have to calculate = with a=20 numeric type too (rwaehrung.w_euro is numeric(9,5))
....................
update KalkPreislisten_float8 SET  kp_ep =3D=20 rkontingent.k_ep::float8 *rwaehrung.w_euro::float= 8=20         -- this doesn't=20 work
 
I discovered, that a calculation float= *=20 float causes, that I can't update tuples in datasheet=20 view.
float * integer works=20 correct
 
What I'm doing wrong?????
Please, let me know, how to realize=20 calculations with type: float * float
 
Thanks in advance
Irina

 
------=_NextPart_000_0056_01C0FD72.14F3E080--