Re: pgScript patch based on pgScript-1.0-beta-3

On Sat, August 16, 2008 15:55, Mickael Deloison wrote:
> 2008/8/14 Erikjan Rijkers <er@xs4all.nl>:
>>  1) It would be nice if pgScript would only execute a select-block, like the
>> normal pgAdmin querytool does.
>
> Do you mean: redirecting a pgScript script to the regular query tool
> if both the pgScript button is pressed and the edit window contains
> only a select statement?

No.

In the regular query tool one can draw a select block (with mouse or
keyboard). Subsequently pressing F5 *only* executes the selected text.  This
is a very handy behaviour that (I think) could be mimicked by pgscript without
problem.
(it makes it easy to quickly test parts of a larger script.)

>>  2) The example script from the url above says:
>>   IF (SELECT 1 FROM table)   -- Then table exists

> You're right, with a count(*) it returns something (0 if no rows) and
> this is true.

Right, thanks.

>>  3) When the BEGIN - END block fails, pgScript executes the ELSE block.
>> This
>> seems questionable behaviour, no?  It can be seen with that same
> I do not understand this observation. Could you be more precise please?

Upon consideration, I might have been mistaken;  I'll test again and look for
a clearly reproducible case.

thanks,

Erikjan