Problems with locking

Поиск
Список
Период
Сортировка
От Familia Ramírez Ramírez
Тема Problems with locking
Дата
Msg-id 001e01c09088$88675800$a491e6d8@explonet.com
обсуждение исходный текст
Список pgsql-interfaces
 
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.

В списке pgsql-interfaces по дате отправления:

Предыдущее
От: "Thies C. Arntzen"
Дата:
Сообщение: Re: PostgreSQL and PHP persistent connections
Следующее
От: Dave Page
Дата:
Сообщение: RE: ODBC for ver 7 (Windows 2000)