Thread: pgScript error when relation name contains ")" symbol

Hi,<br />I have pgScript error when relation name contains ")" symbol,<br />try this example (just execute by F6 -
pgScript):<br/><br />CREATE TABLE "table1)d"<br />(<br />  code character varying(10)<br />)<br />WITH (<br />  
OIDS=FALSE<br/>);<br /><br />(its executed normally by F5).<br />Windows XP rus, PGAdmin 1.14.3, PostgreSQL 9.1.4.<br
/><br/>Thank you.<br /><br /> 

Maybe "pgScript" is something special.

Normally I execute my multi-statement SQL script files using the "Execute Query" 
plain green arrow, which works fine.

I recalled that when I tried the "Execute pgScript" button using the exact same 
SQL, it gave errors.

-- Darren Duncan

Vjacheslav A. wrote:
> Hi,
> I have pgScript error when relation name contains ")" symbol,
> try this example (just execute by F6 - pgScript):
> 
> CREATE TABLE "table1)d"
> (
>   code character varying(10)
> )
> WITH (
>   OIDS=FALSE
> );
> 
> (its executed normally by F5).
> Windows XP rus, PGAdmin 1.14.3, PostgreSQL 9.1.4.
> 
> Thank you.
> 

On Sun, 2012-07-08 at 19:18 +0400, Vjacheslav A. wrote:
> Hi,
> I have pgScript error when relation name contains ")" symbol,
> try this example (just execute by F6 - pgScript):
> 
> CREATE TABLE "table1)d"
> (
>   code character varying(10)
> )
> WITH (
>   OIDS=FALSE
> );
> 
> (its executed normally by F5).
> Windows XP rus, PGAdmin 1.14.3, PostgreSQL 9.1.4.
> 
> Thank you.

You're right, this is a bug. I created a ticket to work on this later.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com