Re: OID Perfomance - another question

From: Tod McQuillin <devin(at)spamcop(dot)net>
To: Mitch Vincent <mitch(at)venux(dot)net>
Cc: josh(at)agliodbs(dot)com, sqllist <pgsql-sql(at)postgresql(dot)org>
Subject: Re: OID Perfomance - another question
Date: 2000-10-03 16:24:28
Message-ID: Pine.LNX.4.21.0010040123350.1978-100000@glass
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Mitch Vincent 2000-10-03 16:35:10 Re: OID Perfomance - Object-Relational databases
Previous Message Mitch Vincent 2000-10-03 16:23:12 Re: OID Perfomance - another question