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

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
>