[Pgcluster-general] large objects and OID collisions

Filip Rembiałkowski plk.zuber at gmail.com
Fri Feb 29 15:21:27 UTC 2008


Hi All

please let me know if I understand correctly

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?




-- 
Filip Rembiałkowski


More information about the Pgcluster-general mailing list