pgAdmin, pgScript and ampersand

Поиск
Список
Период
Сортировка
От Matthieu Pepin
Тема pgAdmin, pgScript and ampersand
Дата
Msg-id BAY171-W114FB8B5864FF0C317DEA4CB03E0@phx.gbl
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: "Paragon Corporation"
Дата:
Сообщение: Feature Request: No gui for creating user mappings
Следующее
От: Guillaume Lelarge
Дата:
Сообщение: Re: Uniform UPDATE queries