pgAdmin, pgScript and ampersand

From: Matthieu Pepin <matthieupepin(at)hotmail(dot)com>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: pgAdmin, pgScript and ampersand
Date: 2012-04-16 18:20:57
Message-ID: BAY171-W114FB8B5864FF0C317DEA4CB03E0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support


Hi,
I'm having a problem with pgAdmin and pgScript. If I do something like this:
CREATE TABLE testtable(description VARCHAR);SET @myvar = 'String with & ampersand';INSERT INTO mytable(desc) VALUES('@myvar');
pgAdmin hangs when I run the script. The timer at the bottom right of the screen just keeps increasing and I can't even cancel the script. It is caused by the ampersand in @myvar. Is there something I can do to make it work or it's really a bug? I'm using pgAdmin 1.14.0 in OpenSUSE 12.1 Tumbleweed.
Thanks a lot!

Browse pgadmin-support by date

  From Date Subject
Next Message Guillaume Lelarge 2012-04-16 20:21:24 Re: Uniform UPDATE queries
Previous Message Paragon Corporation 2012-04-16 13:15:09 Feature Request: No gui for creating user mappings