X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 5340211F61E9 for ; Tue, 18 Apr 2006 00:57:10 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: 0.128 X-Spam-Level: X-Spam-Status: No, score=0.128 required=5 tests=[AWL=0.128] Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id mvj77VQ97rja for ; Tue, 18 Apr 2006 00:57:07 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id A284211F61E8 for ; Tue, 18 Apr 2006 00:57:07 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k3I3v41e009385; Mon, 17 Apr 2006 23:57:04 -0400 (EDT) To: Jim Nasby cc: pgsql-admin@postgresql.org Subject: Re: DDL commands don't handle OID wrap In-reply-to: References: <20060417193829.GN49405@pervasive.com> <4551.1145303173@sss.pgh.pa.us> Comments: In-reply-to Jim Nasby message dated "Mon, 17 Apr 2006 17:09:15 -0500" Date: Mon, 17 Apr 2006 23:57:04 -0400 Message-ID: <9384.1145332624@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200604/152 X-Sequence-Number: 21321 Jim Nasby writes: > Also, in 8.1, here's a list of tables in pg_catalog that don't appear > to have unique constraints on oid... do these all look safe? I'd be a bit surprised to find such a constraint on any of these, seeing that they don't have oids. regards, tom lane