JDBC postgres statement_timeout

Question

Suppose I have:

untimedStatement = connection.createStatement() ;
timedStatement = connection.createStatement();

And then run

timedStatement.execute("SET statement_timeout TO " + timeout);

Will the SET statement_timeout command also affect untimedStatement? I was hoping it would not but some of the behaviour I'm observing suggests that SET statement_timeout has a "universal" effect (at least for the life of the program)

Magnus Hagander · Accepted Answer · 2009-07-25 09:26:43Z

4

Yes, as long as they are executed on the same connection.

You can use SET LOCAL statement_timeout to make it affect only the current transaction. Details.

answered Jul 25, 2009 at 9:26

Magnus Hagander

25.5k6 gold badges60 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

JDBC postgres statement_timeout

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related