How to close transaction?

Поиск
Список
Период
Сортировка
От ds@ics.elcom.ru
Тема How to close transaction?
Дата
Msg-id Pine.LNX.4.04.9909021932200.11694-100000@ics.elcom.ru
обсуждение исходный текст
Список pgsql-general
Hello,

If I use RAISE EXCEPTION operator in stored procedure, should I call
ROLLBACK in client application to complete the transaction?

Now I'm getting notice from postgres backend:

UserAbortTransactionBlock and not in in-progress state

It seems to me I call ROLLBACK when the transaction does not exist
already? Am I right?

Where can I read more about different notice and error messages?

Thanks,

Dmitry Sorokin








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