Robert Treat wrote: >>I think statement_timeout and lock_timeout are different. >> >>If I set statement_timeout to 1000 to detect a lock timeout, >>I can't run a query which takes over 1 sec. >> >>If a lock wait is occured, I want to detect it immediately, >>but I still want to run a long-running query. > > How is your problem not solved by NOWAIT? > http://developer.postgresql.org/docs/postgres/sql-lock.html
I agree that it's one of the solutions when we use LOCK explicitly. But LOCK does only lock a whole table, doesn't it? -- NAGAYASU Satoshi <[EMAIL PROTECTED]> ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html