I've playing for a while with differents versions of postgreSQL (to be exact, versions 7.2.2, 7.3.3 and 7.3.4) and I noticed that the only one that dumped/restored correctly a database with blob's was version 7.3.4.
I made a dump by the book, without OID's. The restoration procedure worked totally fine with version 7.3.4 ( including the recalculation of OID's ). I tryed dumping with version 7.3.3 and restoring the dump with version 7.3.4 (which worked fine for me) so I think the problem is pg_restore.
May anyone report succesfull restoration with previous versions of 'pg_restore' ? I think someone pointed that pg_restore was a little buggy in previous versions, Am I right ?
Gustavo Pérez
---------------------------(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
