Обсуждение: statement_timeout

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

statement_timeout

От
Bruce Momjian
Дата:
In my original statement_timeout code, if a query string had multiple
statements, I would time the statements individually.  I have modified
it so it now times the entire string collectively.

Do people realize that if you pass a single string to the backend, it
makes the string into a single transaction?
"UPDATE tab SET x=1;UPDATE tab SET y=2;"

is treated as one transaction.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026