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

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.

-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

<div dir="ltr"><div class="gmail_default"
style="font-family:arial,helvetica,sans-serif;font-size:small;display:inline">HiDave,<br /></div><br />On Thu, Jan 16,
2014at 4:58 PM, Dave Page <span dir="ltr"><<a href="mailto:dpage@pgadmin.org"
target="_blank">dpage@pgadmin.org</a>></span>wrote:<br /><div class="gmail_extra"><div
class="gmail_quote"><blockquoteclass="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc
solid;padding-left:1ex"><divclass="HOEnZb"><div class="h5">On Thu, Jan 16, 2014 at 12:06 AM, Sam Mesh <<a
href="mailto:Sam.Mesh@gmail.com">Sam.Mesh@gmail.com</a>>wrote:<br /> > In my pgAdmin, F5 (execute query) works
butF6 (execute pgScript) doesn't<br /> > work:<br /> ><br /> > with T as (select * from
TECHNICAL_DESCRIPTOR)select* from T;<br /> ><br /> >    [ERROR    ] 1.0: syntax error, unexpected character<br
/><br/></div></div>Hmm, yeah - I guess the pgScript parser hasn't be taught that "WITH"<br /> is now a valid SQL
command.Dinesh, could you look into that please? I<br /> guess it's just a case of adding WITH as a keyword.<br /><span
class="HOEnZb"><fontcolor="#888888"><br /></font></span></blockquote><div class="gmail_default"
style="font-family:arial,helvetica,sans-serif;font-size:small">Sure,i will look into this case.<br /><br /></div><div
class="gmail_default"style="font-family:arial,helvetica,sans-serif;font-size:small"> Thanks,<br /></div><div
class="gmail_default"style="font-family:arial,helvetica,sans-serif;font-size:small">Dinesh<br /></div><blockquote
class="gmail_quote"style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="HOEnZb"><font
color="#888888">--<br /> Dave Page<br /> Blog: <a href="http://pgsnake.blogspot.com"
target="_blank">http://pgsnake.blogspot.com</a><br/> Twitter: @pgsnake<br /><br /> EnterpriseDB UK: <a
href="http://www.enterprisedb.com"target="_blank">http://www.enterprisedb.com</a><br /> The Enterprise PostgreSQL
Company<br/></font></span></blockquote></div><br /></div></div>