Re: Parameter setting in multi-statement command; I got bit today

Jerry Sievers <gsievers19@comcast.net> writes:
> Just FYI... maybe I'm the only Pg veteran who didn't know this but;
> Parameter settings in a multi-statement command are not in effect for
> later statements in same command.

This is not a true statement in general.

> They will take effect on later
> commands however as seen below.
> The 2 seconds statement timeout does nothing to prevent the sleep(10)
> from completing.

I believe what's happening there is that the timeout is applied to each
submitted query string, not individual statements within such a string.

            regards, tom lane