Mark Steben wrote:
I'm running version 7.4.5. Do I have to do a drop-recreate or is there Some other way around this?
There has been mention that some of the old versions of 7.x had data critical issues that are fixed in newer updates.
My first suggestion would be to try it with 7.4.19 (using a copy of your data files of course)
As well as planning an upgrade to 8.1 or 8.2 -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz ---------------------------(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
