Re: tsvector that can't be dumped/reloaded in 8.3beta

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jeff Davis <pgsql(at)j-davis(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org, Teodor Sigaev <teodor(at)sigaev(dot)ru>
Subject: Re: tsvector that can't be dumped/reloaded in 8.3beta
Date: 2007-11-02 18:25:37
Message-ID: 16171.1194027937@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Jeff Davis <pgsql(at)j-davis(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2007-11-02 19:16:21 Re: BUG #3713: problem with thread safety???
Previous Message Radim Kolar 2007-11-02 18:08:26 BUG #3714: applications using COPY are now much slower