Re: CTE error for F6 (execute pgScript), F5 (execute query) is OK

It looks like the same story with 'do':

do $$ declare i int; begin i:= 0; end$$;

On Wed, Jan 22, 2014 at 6:18 PM, Dinesh Kumar <dinesh(dot)kumar(at)enterprisedb(dot)com
> wrote:

> Hi Dave,
>
> On Thu, Jan 16, 2014 at 4:58 PM, Dave Page <dpage(at)pgadmin(dot)org> wrote:
>
>> On Thu, Jan 16, 2014 at 12:06 AM, Sam Mesh <Sam(dot)Mesh(at)gmail(dot)com> wrote:
>> > In my pgAdmin, F5 (execute query) works but F6 (execute pgScript)
>> doesn't
>> > work:
>> >
>> > with T as (select * from TECHNICAL_DESCRIPTOR)select * from T;
>> >
>> > [ERROR ] 1.0: syntax error, unexpected character
>>
>> Hmm, yeah - I guess the pgScript parser hasn't be taught that "WITH"
>> is now a valid SQL command. Dinesh, could you look into that please? I
>> guess it's just a case of adding WITH as a keyword.
>>
>> Sure, i will look into this case.
>
> Thanks,
> Dinesh
>
>> --
>> Dave Page
>> Blog: http://pgsnake.blogspot.com
>> Twitter: @pgsnake
>>
>> EnterpriseDB UK: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>
>