Re: Parameter setting in multi-statement command; I got bit today - Mailing list pgsql-general

From Tom Lane
Subject Re: Parameter setting in multi-statement command; I got bit today
Date
Msg-id 26382.1333312369@sss.pgh.pa.us
Whole thread Raw
In response to Parameter setting in multi-statement command; I got bit today  (Jerry Sievers <gsievers19@comcast.net>)
Responses Re: Parameter setting in multi-statement command; I got bit today
List pgsql-general
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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Trigger.. AFTER and BEFORE with specific column changed
Next
From: Jerry Sievers
Date:
Subject: Re: Parameter setting in multi-statement command; I got bit today