I have been using postgresql (7.2.1-5) for several years. Supprisingly, I've just got a problem when doing pg_dumpall. The error is : psql: ERROR: getTypeOutputInfo: Cache lookup of type 0 failed This error also occurs when i enter to postgres using this command: psql template1 User which i used was postgres. Can anybody help me to overcome this problem. I need to dump all database since i want to upgrade to 8.0.3. Thanks Raufari ____________________________________________________ Start your day with Yahoo! - make it your home page http://www.yahoo.com/r/hs ---------------------------(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
