Re: CTE error for F6 (execute pgScript), F5 (execute query) is OK
| От | Sam Mesh |
|---|---|
| Тема | Re: CTE error for F6 (execute pgScript), F5 (execute query) is OK |
| Дата | |
| Msg-id | CACi6F2mzGVjpbVRkH1MxHE+CbEJRwg6nA9EQ84ditpg1D6u4rQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: CTE error for F6 (execute pgScript), F5 (execute query) is OK (Dinesh Kumar <dinesh.kumar@enterprisedb.com>) |
| Ответы |
Re: CTE error for F6 (execute pgScript), F5
(execute query) is OK
|
| Список | pgadmin-support |
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,Hmm, yeah - I guess the pgScript parser hasn't be taught that "WITH"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
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 по дате отправления: