Re: Statement timeout

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.