[Pgcluster-general] large objects and OID collisions

[At.Mitani]

Hi Filip,

I recommend to use pg_dump with -d option.
When insert large object, collision of oid will be prevented.

(see "inv_create()" in "backend/storage/large_object/inv_api.c")

Regards,

> I want to transfer a table with large objects from one db (8.1) to
> another (8.1 or later).
> 
> I'm creating a dump with a plain pg_dump DBNAME, and editing this to
> include only interesting table and large objects.
> 
> then I load it into another database
> 
> this another database could have  higher OID counter.
> 
> this will cause collisions on restore, right? or am I getting anything wrong?
> 
> is there a good, robust solution for this problem?

-- 
At.Mitani <mitani at sraw.co.jp>