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.