pgAdmin, pgScript and ampersand - Mailing list pgadmin-support

From Matthieu Pepin
Subject pgAdmin, pgScript and ampersand
Date
Msg-id BAY171-W114FB8B5864FF0C317DEA4CB03E0@phx.gbl
Whole thread Raw
List 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!

pgadmin-support by date:

Previous
From: "Paragon Corporation"
Date:
Subject: Feature Request: No gui for creating user mappings
Next
From: Guillaume Lelarge
Date:
Subject: Re: Uniform UPDATE queries