Re: Something's not (de)compressing right

On Mon, 8 Dec 2003, Tom Lane wrote:

> Elliot Lee <sopwith@redhat.com> writes:
> > http://archives.postgresql.org/pgsql-hackers/2000-07/msg00483.php
> > I'm having this same problem with postgresql 7.3.4.
> 
> You aren't having the "same" problem, because that UNION bug was fixed
> ages ago.

You're right. However, I saw the exact same symptoms, with a very similar
stack trace.

> > Easy to reproduce by running an 'INSERT' query.
> 
> Let's see the test case then ...

A 'REINDEX' made the symptoms go away. Nice for me, unfortunate for fixing
postgresql. :\

I do have another bug related to vacuuming tables that contain binary
large objects, inside a UTF-8 encoded database. If that's not a known
issue, I'll work up a reproduction case for that.

-- Elliot
http://www.barbiecollectibles.com/shop/product.aspx?sku=B3449
One ring to rule the malls, a website to supply them. The Tolkien "Ken and
Barbie" dolls - now 60 bucks can buy them!