Deadlock Detection

Поиск
Список
Период
Сортировка
От Moshe Vardi
Тема Deadlock Detection
Дата
Msg-id 200310271717.h9RHHbQj016685@verif.cs.rice.edu
обсуждение исходный текст
Список pgsql-hackers
How do I find out in Embedded SQL that a transaction has been aborted
due to a deadlock?

The closes error message in sqlca seems to be:
 -401 (ECPG_TRANS): Error in transaction processing line %d.  PostgreSQL signaled that we cannot start, commit, or
rollbackthe  transaction. 
 

but it does not seem to be informative enough.

Similarly, how do I find if a transaction has been aborted due to
nonserializability?

Thanks,
Moshe



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

Предыдущее
От: "Thiago Fernandes Moesch"
Дата:
Сообщение: When the last vacuum occured? It's necessary to run it now?
Следующее
От: strk
Дата:
Сообщение: Re: DETOASTing in custom memory context