Re: tsvector that can't be dumped/reloaded in 8.3beta - Mailing list pgsql-bugs

From Tom Lane
Subject Re: tsvector that can't be dumped/reloaded in 8.3beta
Date
Msg-id 16171.1194027937@sss.pgh.pa.us
Whole thread Raw
In response to tsvector that can't be dumped/reloaded in 8.3beta  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-bugs
Jeff Davis <pgsql@j-davis.com> writes:
> I was unable to dump from beta1 to beta2, and I narrowed it down to this
> simpler case:

> test=> select tsvectorin(tsvectorout(
>     to_tsvector($foo$ a.b.cd/x=mnop.q\  $foo$)
>     ));
> ERROR:  syntax error in tsvector: "'a.b.cd':2 'a.b.cd/x':1 '/x=mnop.q
> \':3"

This looks like the already-known issue that tsvectorout fails to double
backslashes ...

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Radim Kolar"
Date:
Subject: BUG #3714: applications using COPY are now much slower
Next
From: Tom Lane
Date:
Subject: Re: BUG #3713: problem with thread safety???