Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154]) by hub.org (8.10.1/8.10.1) with ESMTP id e943b4G42276 for ; Tue, 3 Oct 2000 23:37:04 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.0/8.11.0) with ESMTP id e943awB02437; Tue, 3 Oct 2000 23:36:58 -0400 (EDT) To: Michael Fork cc: Josh Berkus , sqllist Subject: Re: OID Perfomance - Object-Relational databases In-reply-to: References: Comments: In-reply-to Michael Fork message dated "Tue, 03 Oct 2000 21:26:29 -0400" Date: Tue, 03 Oct 2000 23:36:57 -0400 Message-ID: <2434.970630617@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200010/47 Michael Fork writes: > Just a thought, but couldn't you create a sequence that is referenced by > multiple tables, I was going to suggest exactly that. It's not quite as simple as a "serial" column declaration, but you can split the use of an ID sequence generator over just as many tables as you need to have unique IDs across. That way you don't have a problem at dump/reload time, and you don't exhaust your ID space any faster than you must. regards, tom lane