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.kumar@enterprisedb.com> wrote:

Hi Dave,

On Thu, Jan 16, 2014 at 4:58 PM, Dave Page <dpage@pgadmin.org> wrote:

On Thu, Jan 16, 2014 at 12:06 AM, Sam Mesh <Sam.Mesh@gmail.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