Re: statement_timeout vs DECLARE CURSOR

2021-09-27 Thread Tom Lane
Christophe Pettus writes: >> On Sep 27, 2021, at 10:42, Christophe Pettus wrote: >> We've encountered some unexpected behavior with statement_timeout not >> cancelling a query in DECLARE CURSOR, but only if the DECLARE CURSOR is >> outside of a transaction: > A bit more poking revealed the rea

Re: statement_timeout vs DECLARE CURSOR

2021-09-27 Thread Christophe Pettus
> On Sep 27, 2021, at 10:42, Christophe Pettus wrote: > We've encountered some unexpected behavior with statement_timeout not > cancelling a query in DECLARE CURSOR, but only if the DECLARE CURSOR is > outside of a transaction: A bit more poking revealed the reason: The ON HOLD cursor's quer

statement_timeout vs DECLARE CURSOR

2021-09-27 Thread Christophe Pettus
Hi, We've encountered some unexpected behavior with statement_timeout not cancelling a query in DECLARE CURSOR, but only if the DECLARE CURSOR is outside of a transaction: xof=# select version(); version

change ownership of schema public?

2021-09-27 Thread Zwettler Markus (OIZ)
A database user is having all its objects into the public schema. Now he requests to become the owner of the public schema to be able to do "reindex schema public". I'm wondering if it is a good idea to change the ownership of the public schema? Are there any possible side effects e.g. regarding