Durumdara wrote: > The pg_catalog schema is system schema, but it is IN the DB. > > Is this true? So OID is not global (out from DB)?
The OID generator is global to the instance, but the unicity checks are local to the tables that use OIDs, including large objects. The case when you may have a problem is if moving large objects from the old instance/old database to the new instance/new database but the new database would already have large objects created before the import. Then you would need to do a merge rather than just an import. But if you're merely in the case that other databases in the new instance have consumed OIDs and some happen to be equal to the ones you want to import in a new database, that doesn't matter: similar OIDs won't conflict if they're in different databases or even the same database but different tables. Best regards, -- Daniel Vérité PostgreSQL-powered mailer: http://www.manitou-mail.org Twitter: @DanielVerite -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
