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

2012-04-01 Thread Jerry Sievers
Tom Lane writes: > Jerry Sievers 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

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

2012-04-01 Thread Tom Lane
Jerry Sievers 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

[GENERAL] Parameter setting in multi-statement command; I got bit today

2012-04-01 Thread Jerry Sievers
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. They will take effect on later commands however as seen below. The 2 seconds statement timeout does nothing to prevent the s