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 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.
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 -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support