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

From: Darren Duncan <darren(at)darrenduncan(dot)net>
To: "Vjacheslav A(dot)" <eferalgan(at)gmail(dot)com>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: pgScript error when relation name contains ")" symbol
Date: 2012-07-08 22:21:18
Message-ID: 4FFA07DE.7030208@darrenduncan.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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.
>

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Martin French 2012-07-09 09:11:26 Re: pgAgent reports failure upon success
Previous Message Vjacheslav A. 2012-07-08 15:18:56 pgScript error when relation name contains ")" symbol