Re: [BUGS] Nasty tsvector can make dumps unrestorable

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Stuart Bishop <stuart(at)stuartbishop(dot)net>, Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>, Teodor Sigaev <teodor(at)sigaev(dot)ru>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [BUGS] Nasty tsvector can make dumps unrestorable
Date: 2007-11-10 16:41:18
Message-ID: 16207.1194712878@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

Bruce Momjian <bruce(at)momjian(dot)us> writes:
> However, I am still unclear if the dump code is correct because I don't
> see the backslash preserved in \\'' cases, just \\\\ cases:

> test=> INSERT INTO Foo(bar) VALUES (E'\\''x');

You're just confused. That produces a word whose contents are the
two characters 'x, so either '\'x' or '''x' would be legitimate
output.

However, I'd prefer to see Teodor fix this, because it needs to be
back-patched too, and I'm not entirely sure if there are other
consequences.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2007-11-10 18:35:42 Re: BUG #3735: Can't create xml-stylesheet processing instruction
Previous Message Andreas 2007-11-10 10:54:08 BUG #3741: translation mistake

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-11-10 16:45:26 Re: data access automatic filter
Previous Message Markus Schiltknecht 2007-11-10 16:38:43 Re: High Availability, Load Balancing, and Replication Feature Matrix