Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-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/

Responses

pgsql-hackers by date

Next:From: Kevin GrittnerDate: 2007-09-28 18:46:16
Subject: Re: [FEATURE REQUEST] Streaming Onlinebackup (MaybeOFFTOPIC)
Previous:From: Tom LaneDate: 2007-09-28 16:41:12
Subject: Re: [FEATURE REQUEST] Streaming Onlinebackup (MaybeOFFTOPIC)

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group