transactions

Поиск

Список

Период

Сортировка

От	Viorel Dragomir
Тема	transactions
Дата	29 июля 2003 г. 16:15:50
Msg-id	031a01c355fd$4f52d020$0600a8c0@fix.ro обсуждение исходный текст
Ответы	Re: transactions
Список	pgsql-sql

Дерево обсуждения

Is there any known issues regarding transactions.

I got something like:

begin transaction

select function1()

select into v1 function2()

if v1='ok' then commit else rollback end if

To notice that both functions have about 100 lines of code.

And both functions uses the same tables but in different modes.

function1 deletes && function2 inserts

The problem is that my web browser hangs on this query and stays that way a lot [like 30 minutes -- i forgot about it and after 30 minutes it was still trying to open the result page]

I hope tomorrow I'll resolv this and if is primary my fault I just shut up and say nothing.

regards,

vioss

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

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

transactions