Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28])
	by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f1CFDUx10667
	for <pgsql-interfaces@postgresql.org>;
	Mon, 12 Feb 2001 10:13:30 -0500 (EST)
	(envelope-from pgsql-interfaces-owner@postgresql.org)
Received: from srv2.explonet.com (e-145-163.telered.net.gt [216.230.145.163]
	(may be forged))
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f19EhVx34245
	for <pgsql-interfaces@postgresql.org>;
	Fri, 9 Feb 2001 09:43:31 -0500 (EST)
	(envelope-from famosos@explonet.com)
Received: from casa.explonet.com (e-145-164.telered.net.gt [216.230.145.164]
	(may be forged))
	by srv2.explonet.com (8.9.3/8.9.3) with SMTP id IAA00349
	for <pgsql-interfaces@postgresql.org>; Fri, 9 Feb 2001 08:47:07 -0600
Message-ID: <001e01c09088$88675800$a491e6d8@explonet.com>
Reply-To: =?iso-8859-1?Q?Familia_Ram=EDrez_Ram=EDrez?= <famosos@explonet.com>
From: =?iso-8859-1?Q?Familia_Ram=EDrez_Ram=EDrez?= <famosos@explonet.com>
To: <pgsql-interfaces@postgresql.org>
Subject: Problems with locking
Date: Tue, 6 Feb 2001 16:02:43 -0600
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_001B_01C09056.3D6832C0"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
X-Archive-Number: 200102/95
X-Sequence-Number: 1050

This is a multi-part message in MIME format.

------=_NextPart_000_001B_01C09056.3D6832C0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


Hi, and thanks for taking the time to answer to our issues.

We're opening a Postgres Database using the windows Odbc driver and program=
ming with Visual Basic.  In some moment, one of our tables got locked the m=
ost (we can only update row 6 ! ) and anyone who tries to update gets a mes=
sage 'You are trying to update a record that is being modified by another u=
ser'  (tha'ts the meaning, text is longer).  BUT if you update the table on=
 the server directly, it works fine !

We've tried to have all users out, even reset the Postgres server, but when=
 we enter it's the same.  We also tried to move data to a text file, recrea=
te the table and import the data again, but when we got data back, error ke=
eps happening on the Windows stations, and you can only modify the table in=
 the server.
=20
It only happened with this specific table

Thanks a lot for your support=20


Edgar Ramirez
Managing a project in Guatemala, Central America.

------=_NextPart_000_001B_01C09056.3D6832C0
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2919.6307" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Hi, and thanks for taking the time to answ=
er to our=20
issues.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>We're opening&nbsp;a Postgres Database usi=
ng the=20
windows Odbc driver and programming with Visual Basic.&nbsp; In some moment=
, one=20
of our tables got locked the most (we can only update row 6 ! ) and anyone =
who=20
tries to update gets a message 'You are trying to update a record that is b=
eing=20
modified by another user'&nbsp; (tha'ts the meaning, text is longer).&nbsp;=
 BUT=20
if you update the table on the server directly, it works fine !</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>We've tried to have all users out, even re=
set the=20
Postgres server, but when we enter it's the same.&nbsp; We also tried to mo=
ve=20
data to a text file, recreate the table and import the data again, but when=
 we=20
got data back, error keeps happening on the Windows stations, and you can o=
nly=20
modify the table in the server.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>It only happened with this specific=20
table</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Thanks a lot for your support </FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Edgar Ramirez</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Managing a project in Guatemala, Central=
=20
America.</FONT></DIV></FONT></DIV></BODY></HTML>

------=_NextPart_000_001B_01C09056.3D6832C0--