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