On Mon, 8 Dec 2003, Tom Lane wrote: > Elliot Lee <[EMAIL PROTECTED]> 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! ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
