Horton
Menu

Re: SELECT ... FOR UPDATE [WAIT integer | NOWAIT] for 8.5

Lucas <lucas75@gmail.com>

View thread
From: Lucas Brito <lucas75@gmail.com>
To: Hans-Juergen Schoenig <postgres@cybertec.at>
Cc: Greg Stark <greg.stark@enterprisedb.com>, pgsql-hackers@postgresql.org
Date: 2009-05-11T09:38:44Z
Lists: pgsql-hackers 
2009/5/11 Hans-Juergen Schoenig <postgres@cybertec.at>


> the thing with statement_timeout is a little bit of an issue.
> you could do:
>   SET statement_timeout TO ...;
>   SELECT FOR UPDATE ...
>   SET statement_timeout TO default;
>

Why not extend the "SET" instruction to allow configuration parameters to be
set only in the duration of the transaction or the next "n" commands?

-- 
Lucas Brito