Bug #524: Bad quoting of backslash in text arrays

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #524: Bad quoting of backslash in text arrays
Date: 2001-11-29 12:06:19
Message-ID: 200111291206.fATC6JD53762@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Ondrej Palkovsky (ondrap(at)penguin(dot)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 that on output the backslash doesn't get doubled, so if you have the combination 'backslash+dquote', you totally confuse the parsing 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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alain Franciosa 2001-11-29 12:33:18 postmaster on solaris
Previous Message Peter Eisentraut 2001-11-28 20:50:09 Re: text(bool), text(numeric)