On 01/29/2016 07:00 AM, Edson Richter wrote:
I've set statement timeout in postgresql.conf to 300s.
Now, I have a schema update procedure at application startup I would
like to run without timeout, or with significant larger timeout (let's
say, 10000s).
It is possible to change statement timeout at runtime before issuing the
command (for one connection only) without changing postgresql.conf?
Yes, use SET
SET statement_timeout TO '$duration';
JD
--
Command Prompt, Inc. http://the.postgres.company/
+1-503-667-4564
PostgreSQL Centered full stack support, consulting and development.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
