Csaba Nagy wrote:
It's version 8.0.almost3, meaning that I used the 8.0 stable CVS branch
just before 8.0.3 was released. I will upgrade this data base to 8.1.x
(the latest released version at the time of upgrade) soon, so if the 8.1
version has the temporary table thing fixed that would be very nice :-)
I also have an instance running 8.0.almost5, so if that has a fix for
the core dump, that would be also nice, cause that instance will not be
migrated to 8.1 very soon.
BTW, did you actually mean to use the 8.1 autovacuum with 8.0 data base
? I can't imagine how that would work :-)
No I didn't mean to use the 8.1 autovac with 8.0, that can't work.
Please upgrade your 8.0.x to at least 8.0.5 and see if that fixes the
problem.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match