From: Familia Ramírez Ramírez <famosos@explonet.com>
To: pgsql-interfaces@postgresql.org
Subject: Problems with locking
Date: Tue, 6 Feb 2001 16:02:43 -0600
Message-ID: <001e01c09088$88675800$a491e6d8@explonet.com> (raw)
Hi, and thanks for taking the time to answer to our issues.
We're opening a Postgres Database using the windows Odbc driver and programming with Visual Basic. In some moment, one of our tables got locked the most (we can only update row 6 ! ) and anyone who tries to update gets a message 'You are trying to update a record that is being modified by another user' (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, recreate the table and import the data again, but when we got data back, error keeps happening on the Windows stations, and you can only modify the table in the server.
It only happened with this specific table
Thanks a lot for your support
Edgar Ramirez
Managing a project in Guatemala, Central America.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: famosos@explonet.com
Subject: Re: Problems with locking
In-Reply-To: <001e01c09088$88675800$a491e6d8@explonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox