Postgres Pro
Downloads
Home   >   mailing lists

Re: SELECT ... FOR UPDATE [WAIT integer | NOWAIT] for 8.5 - Mailing list pgsql-hackers

From Lucas Brito
Subject Re: SELECT ... FOR UPDATE [WAIT integer | NOWAIT] for 8.5
Date
Msg-id cccdaefb0905110238j1d3124dfn73c6dab5c63b02fb@mail.gmail.com
Whole thread Raw
In response to Re: SELECT ... FOR UPDATE [WAIT integer | NOWAIT] for 8.5  (Hans-Juergen Schoenig <postgres@cybertec.at>)
Responses Re: SELECT ... FOR UPDATE [WAIT integer | NOWAIT] for 8.5  (Bernd Helmle <mailings@oopsware.de>)
List pgsql-hackers
Tree view
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

pgsql-hackers by date:

Previous
From: Hans-Juergen Schoenig
Date:
Subject: Re: SELECT ... FOR UPDATE [WAIT integer | NOWAIT] for 8.5
Next
From: Bernd Helmle
Date:
Subject: Re: SELECT ... FOR UPDATE [WAIT integer | NOWAIT] for 8.5