Bug #524: Bad quoting of backslash in text arrays

Поиск
Список
Период
Сортировка
От pgsql-bugs@postgresql.org
Тема Bug #524: Bad quoting of backslash in text arrays
Дата
Msg-id 200111291206.fATC6JD53762@postgresql.org
обсуждение исходный текст
Ответы Re: Bug #524: Bad quoting of backslash in text arrays
Список pgsql-bugs
Ondrej Palkovsky (ondrap@penguin.cz) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
Bad quoting of backslash in text arrays

Long Description
I'm using text arrays to store some information. Unfortunately I got some text that contained backslash. The problem is
thaton output the backslash doesn't get doubled, so if you have the combination 'backslash+dquote', you totally confuse
theparsing modules (both PoPy and PyPgSql).  

Sample Code
create table test (
a text[]
);
insert into test values ('{"aaa\\\\bbb\\"ccc"}');
select * from test;
{"aaa\bbb\"ccc"}
Note that the backslash between aaa and bbb should be doubled.

No file was uploaded with this report

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: text(bool), text(numeric)
Следующее
От: Alain Franciosa
Дата:
Сообщение: postmaster on solaris