On Thu, Jan 16, 2014 at 12:06 AM, Sam Mesh <sam.m...@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 -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support