Thread: pgAdmin pgScript and ampersand
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 testtable(description) 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!
On Sun, 2012-04-22 at 19:19 -0400, Matthieu Pepin wrote:
> 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 testtable(description)
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
evencancel the script. It is caused by the ampersand in @myvar. Is there something I can do to make it work or it's
reallya bug? I'm using pgAdmin 1.14.0 in OpenSUSE 12.1 Tumbleweed.
Sorry, I thought I already replied to your mail.
So, I tried and you're right. It hangs when you add an ampersand in the
string. There's nothing in the documentation saying you're not allowed
to use an ampersand, so it's clearly a bug. I don't have time right now
to fix it, so I added a ticket to fix this bug later.
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com