Hi guys,
I just thought I'd let you know that i just dumped our production database with 8.0's pg_dumpall and reloaded it into a test 8.0 database.
It worked.
No errors.
For the first time in our company's history with PostgreSQL, we can upgrade without editing the dump file!!!
I feel like my life's work is complete :D
Chris
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match