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 C2C959DC816 for ; Tue, 20 Dec 2005 11:57:04 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 07199-03 for ; Tue, 20 Dec 2005 11:57:09 -0400 (AST) 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 2824D9DC82D for ; Tue, 20 Dec 2005 11:57:01 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id jBKFv4u1029846; Tue, 20 Dec 2005 10:57:04 -0500 (EST) To: "Donald Fraser" cc: "[ADMIN]" Subject: Re: WITH SYSID feature dropped In-reply-to: <011501c60578$47642e40$0264a8c0@demolish1> References: <011501c60578$47642e40$0264a8c0@demolish1> Comments: In-reply-to "Donald Fraser" message dated "Tue, 20 Dec 2005 15:15:49 +0000" Date: Tue, 20 Dec 2005 10:57:04 -0500 Message-ID: <29845.1135094224@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.021 required=5 tests=[AWL=0.021] X-Spam-Score: 0.021 X-Spam-Level: X-Archive-Number: 200512/223 X-Sequence-Number: 19943 "Donald Fraser" writes: > 1) Was there a good reason for dropping this feature? Users/groups are identified by OIDs now, not by sysids. The original motivation for allowing manual assignment of userids was to allow recovery if a user was dropped while still owning objects --- you could recreate the user with the same sysid and then the objects' owner fields would match up. 8.1 now does reference counting and prevents you from dropping users who still own anything, so AFAICS that use-case is gone. Do you have another one? regards, tom lane