Обсуждение: How to close transaction?

Поиск
Список
Период
Сортировка

How to close transaction?

От
ds@ics.elcom.ru
Дата:
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