Postgres Pro
Downloads
Home   >   mailing lists

Re: OID Perfomance - another question - Mailing list pgsql-sql

From Tod McQuillin
Subject Re: OID Perfomance - another question
Date
Msg-id Pine.LNX.4.21.0010040123350.1978-100000@glass
Whole thread Raw
In response to Re: OID Perfomance - another question  ("Mitch Vincent" <mitch@venux.net>)
List pgsql-sql
Tree view 
On Tue, 3 Oct 2000, Mitch Vincent wrote:

> Aren't there a pretty big concerns when using OIDs as IDs to relate records
> in different tables to each other? Wouldn't the OIDs be totally re-assigned
> if you had to dump/restore your database?

Not if you use the -o flag to pg_dump.
      -o     Dump object identifiers (OIDs) for every table.
-- 
Tod McQuillin

pgsql-sql by date:

Previous
From: "Mitch Vincent"
Date:
Subject: Re: OID Perfomance - another question
Next
From: "Mitch Vincent"
Date:
Subject: Re: OID Perfomance - Object-Relational databases