On Wed, Mar 11, 2009 at 5:51 PM, Mickael Deloison <mdeloison@gmail.com> wrote:
> 2009/3/11 Dave Page <dpage@pgadmin.org>:
>> Testing on Windows, it fails the first tests I try :-(
>>
>> select * from missing_table
>>
>> I get no error message at all. If I enter garbage, I just get the following:
>>
>> 1.0: syntax error, unexpected character
>
> This is normal: you do not have anything in the output because the
> query must be terminated with a semi-colon.
> I will look at that and add an error message.
Thanks - I think that would quickly become a gotcha otherwise!
> Add the semi-colon ";" and the query will be executed. An erroneous
> query (like this one where the table does not exist) is valid from the
> pgScript point of view. It returns a warning saying why the query did
> not work but does not stop. I wanted to do like this because sometimes
> with pgScript I test invalid queries and I do not want the script to
> be stopped.
OK.
> Add an empty line at the end and the error will go away. This is the
> way pgScript detects comments: the regular expression doing that is
> "--".*$. I need to see if I can add "End of file" is addition to "$".
Urgh.
>
> The problem you mentioned are things to improve but they have always
> been there and not linked to a recent patch.
OK, cool. I've committed the patch.
Thanks!
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com