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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
