X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8F7F5DBEDD for ; Fri, 25 Nov 2005 23:22:37 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 42942-01 for ; Sat, 26 Nov 2005 03:22:40 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from yertle.kcilink.com (yertle.kcilink.com [65.205.34.180]) by svr1.postgresql.org (Postfix) with ESMTP id 30EB1DBE79 for ; Fri, 25 Nov 2005 23:22:33 -0400 (AST) Received: from [192.168.1.6] (unknown [192.168.1.6]) by yertle.kcilink.com (Postfix) with ESMTP id A0A07B80D for ; Fri, 25 Nov 2005 22:22:37 -0500 (EST) Mime-Version: 1.0 (Apple Message framework v746.2) In-Reply-To: <20051123154522.GC26927@surnet.cl> References: <43847C29.8050800@lake-lotawana.mo.us> <20051123154522.GC26927@surnet.cl> Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <8F8824BE-4B24-42CB-9499-CE2A2FF3DA58@khera.org> Content-Transfer-Encoding: 7bit From: Vivek Khera Subject: Re: sysid Date: Fri, 25 Nov 2005 22:22:38 -0500 To: pgsql-sql@postgresql.org X-Mailer: Apple Mail (2.746.2) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.014 required=5 tests=[AWL=0.014] X-Spam-Score: 0.014 X-Spam-Level: X-Archive-Number: 200511/248 X-Sequence-Number: 23499 On Nov 23, 2005, at 10:45 AM, Alvaro Herrera wrote: > A. R. Van Hook wrote: >> It seems that in 8.1.0 we can no longer set the SYSID when adding >> users >> and groups. >> i.e >> template1=# create role hooker sysid 1345; >> NOTICE: SYSID can no longer be specified >> >> I have lots of code that depends on the actual group and user number. >> Is there a way to set the user and group number? > > No -- fix the code. Just curious, how can user code depend on the > SYSIDs? I don't see a way. > If 8.1 doesn't allow you to remove a user who still has rights granted, then this should be no problem. however, in older versions you can delete users and leave dangling rights with no way to revoke them unless you create a user with that specific ID and then revoke the rights, and re-delete the user.