Received: from glass.pun-pun.prv (IDENT:root@ip12.dialup9.tokyo.jp.psi.net [154.33.243.12]) by hub.org (8.10.1/8.10.1) with ESMTP id e93GP9r28473 for ; Tue, 3 Oct 2000 12:25:10 -0400 (EDT) Received: from localhost (devin@localhost) by glass.pun-pun.prv (8.9.3/8.9.3) with ESMTP id BAA02080; Wed, 4 Oct 2000 01:24:31 +0900 X-Authentication-Warning: glass.pun-pun.prv: devin owned process doing -bs Date: Wed, 4 Oct 2000 01:24:28 +0900 (JST) From: Tod McQuillin X-Sender: devin@glass To: Mitch Vincent cc: josh@agliodbs.com, sqllist Subject: Re: OID Perfomance - another question In-Reply-To: <00b701c02d56$3a301180$0200000a@doot> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200010/34 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