Request a Demo
Home   >   mailing lists

Re: CTE error for F6 (execute pgScript), F5 (execute query) is OK - Mailing list pgadmin-support

From Dinesh Kumar
Subject Re: CTE error for F6 (execute pgScript), F5 (execute query) is OK
Date
Msg-id CAKWsr7h3w4NiMcPCn_nCcwHSqd6JqOiNNU9KU52KE0QEFb6o4Q@mail.gmail.com
Whole thread
In response to Re: CTE error for F6 (execute pgScript), F5 (execute query) is OK  (Dave Page <dpage@pgadmin.org>)
Responses Re: CTE error for F6 (execute pgScript), F5 (execute query) is OK
List pgadmin-support
Tree view
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

pgadmin-support by date:

Previous
From: Devon Oslund
Date:
Subject: Connect to server silently fails with no error message
Next
From: Martin French
Date:
Subject: Re: Connect to server silently fails with no error message