statement_timeout

Started by Bruce Momjianalmost 24 years ago1 messageshackers
Jump to latest
#1Bruce Momjian
bruce@momjian.us

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, Pennsylvania 19026