Jerry Sievers <gsievers19(at)comcast(dot)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