Re: Are duplicated OIDs troublesome? - Mailing list pgsql-general

From Tom Lane
Subject Re: Are duplicated OIDs troublesome?
Date
Msg-id 14208.1001172706@sss.pgh.pa.us
Whole thread Raw
In response to Are duplicated OIDs troublesome?  (David Santinoli <u235@libero.it>)
List pgsql-general
David Santinoli <u235@libero.it> writes:
> going to dump/reload the databases WITH OIDS, and there's a high risk
> that some rows in the first database will have same OIDs as some rows
> from the second one. As long as the clashing rows belong to different
> databases, however, it seems there's no trouble with them. To which
> extent is this correct?

The system won't mind.  There are duplicate OIDs in every database
already --- consider system tables like pg_class, which have the
same OID in every DB, even though they're different tables.

            regards, tom lane

pgsql-general by date:

Previous
From: Vince Vielhaber
Date:
Subject: Re: creating "user" table
Next
From: "Gurunandan R. Bhat"
Date:
Subject: Problem while logging primary key of updated field.