Nasty tsvector can make dumps unrestorable

From: Stuart Bishop <stuart(at)stuartbishop(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Nasty tsvector can make dumps unrestorable
Date: 2007-09-28 17:04:38
Message-ID: 46FD3426.9090300@stuartbishop.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

To continue our streak of bad luck, here is the second tsearch2 bug we found
this week.

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.

This script only tested with PG 8.2.5 under Ubuntu Feisty so far, although
we found the original problem under 8.2.4 on Ubuntu Dapper.

Also reported in the Ubuntu bug tracker at:

https://bugs.launchpad.net/ubuntu/+source/postgresql-8.2/+bug/146382

--
Stuart Bishop <stuart(at)stuartbishop(dot)net>
http://www.stuartbishop.net/

Attachment Content-Type Size
unrestorabledb.sql text/x-sql 1.5 KB

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Lori 2007-09-28 18:29:20 BUG #3643: problems downloading from mirrors
Previous Message Arley Wilches Marcelo 2007-09-28 16:49:02 BUG #3642: Tiempos de consultas diferentes

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Grittner 2007-09-28 18:46:16 Re: [FEATURE REQUEST] Streaming Onlinebackup (Maybe OFFTOPIC)
Previous Message Tom Lane 2007-09-28 16:41:12 Re: [FEATURE REQUEST] Streaming Onlinebackup (MaybeOFFTOPIC)