Dave Page <dpage@vale-housing.co.uk> writes:
> Postgres itself doesn't care. However, up till a day or two ago the
> ODBC driver would change its behavior depending on leading spaces.
>
> You will probably find that the above-quoted hack no longer works
> with the current-CVS ODBC driver ...
>
>>
>> Awwww nuts! If that's the case pgAdmin has just broken in
>> numerous places :-(. I'll have to test it...
> Just recompiled the driver and it still works :-)
Okay. Now that I look at it, the change I was thinking of wouldn't have
affected the behavior for utility statements anyway. What was broken
was statement_type() in statement.c --- it would fail to recognize any
statement with leading spaces, and would always return STMT_TYPE_OTHER.
But that is the right answer for VACUUM and suchlike. The case it
really crashed and burned on was SELECT with leading spaces...
regards, tom lane