general question on OIDs

From: Oliver Vecernik <vecernik(at)aon(dot)at>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: general question on OIDs
Date: 2001-05-05 17:21:42
Message-ID: 3AF436A6.8BFAC3FD@aon.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

Using of OIDs as foreign keys is recommended in the docs. It is a unique
number for every object of the PostgreSQL server. I can dump OIDs with
-o option.

But what happens if I have to upgrade my server? For example for the new
7.1 release an initdb is required. OIDs start from 16384 or something.
After importing my old databases can I expect that OIDs are not unique
any more? Or is there any other handling to prevent this?

Regards,
Oliver

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2001-05-06 04:36:02 Re: general question on OIDs
Previous Message Peter Eisentraut 2001-05-05 14:52:30 Re: PostgreSQL 7.1 now in OpenBSD ports/packages