Re: Nasty tsvector can make dumps unrestorable

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stuart Bishop <stuart(at)stuartbishop(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org, Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>, Teodor Sigaev <teodor(at)sigaev(dot)ru>
Subject: Re: Nasty tsvector can make dumps unrestorable
Date: 2007-09-29 18:45:40
Message-ID: 8464.1191091540@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

Stuart Bishop <stuart(at)stuartbishop(dot)net> writes:
> The attached script creates a tsvector with a value that can be dumped using
> pg_dump, but not loaded again using pg_restore. This causes restores of a
> dump containing this value to fail.

Hmm, sorta looks like tsvectorout should be doubling backslashes?

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Eric Haszlakiewicz 2007-10-01 00:43:49 BUG #3645: regular expression back references seem broken
Previous Message keith atkinson 2007-09-29 10:24:43 BUG #3644: website no showing playlist for radio

Browse pgsql-hackers by date

  From Date Subject
Next Message Gregory Stark 2007-09-30 00:45:59 Re: Something's been bugging me
Previous Message Tom Lane 2007-09-29 17:41:01 Re: Something's been bugging me