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

Поиск
Список
Период
Сортировка
От Dinesh Kumar
Тема Re: CTE error for F6 (execute pgScript), F5 (execute query) is OK
Дата
Msg-id CAKWsr7h3w4NiMcPCn_nCcwHSqd6JqOiNNU9KU52KE0QEFb6o4Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: CTE error for F6 (execute pgScript), F5 (execute query) is OK  (Dave Page <dpage@pgadmin.org>)
Ответы Re: CTE error for F6 (execute pgScript), F5 (execute query) is OK  (Sam Mesh <Sam.Mesh@gmail.com>)
Список pgadmin-support
<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> 

В списке pgadmin-support по дате отправления:

Предыдущее
От: Devon Oslund
Дата:
Сообщение: Connect to server silently fails with no error message
Следующее
От: Martin French
Дата:
Сообщение: Re: Connect to server silently fails with no error message