PSQLODBC and TRANSACTIONS

Поиск
Список
Период
Сортировка
От Jose' Soares
Тема PSQLODBC and TRANSACTIONS
Дата
Msg-id 369B1C13.9E56EE17@sferacarta.com
обсуждение исходный текст
Список pgsql-interfaces
Hi,

I'm trying transactions using M$-access and PSQLODBC without success,
Seems that backend locks itself
by opening two connections to work on the same table.

I have a table with 3 rows:

codice    nome        cap
---------------------------
1    pippo        0
2    pluto        0
3    topolino    0
---------------------------

I tryed to update table as:

UPDATE operatori SET cap = 1;

This works, but the next...

UPDATE operatori SET cap = 2;

At this point the backend was locked and I had to break connection...

(See attached log file)

Thanks for any help.

-Jose'-

Вложения

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

Предыдущее
От: "David Weiss"
Дата:
Сообщение: PostgreSQL and VB5
Следующее
От: "Hu Yu"
Дата:
Сообщение: How to connect with Oracle for NT?