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
