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!