Please can anyone confirm (or otherwise) the situation with restoring large objects?
I am running with 7.1.2 (I know it's old, but I don't have a lot of choice given the application running on it), and have dumped the database with the -b option. However, the restoration process generates new ids for the large objects which means the link between the data table referencing them and the content of pg_largeobject is lost. I have seen a reference in the list archives to this being a bug, but can not find any reference to a workround or resolution. Does anyone know if there is one? I have a separate newer installation on 7.3.4. Is this still a problem on the newer versions? Many thanks for any assistance Marion ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend