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 23CEFDBA2B for ; Wed, 23 Nov 2005 11:41:03 -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 20388-05-4 for ; Wed, 23 Nov 2005 15:41:04 +0000 (GMT) X-Greylist: delayed 01:12:46.751631 by SQLgrey- Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25]) by svr1.postgresql.org (Postfix) with ESMTP id A105DDB5CC for ; Wed, 23 Nov 2005 11:40:55 -0400 (AST) Received: from laker.lake-lotawana.mo.us (anubis.duboislc.org [206.114.195.111]) by svr2.postgresql.org (Postfix) with ESMTP id 5E71EF0B27 for ; Wed, 23 Nov 2005 14:28:14 +0000 (GMT) Received: from [192.168.1.2] (pcp0011972217pcs.indpnd01.mo.comcast.net [69.247.198.159]) by laker.lake-lotawana.mo.us (8.12.8/8.12.8) with ESMTP id jANERMrB014796 for ; Wed, 23 Nov 2005 08:27:52 -0600 Message-ID: <43847C29.8050800@lake-lotawana.mo.us> Date: Wed, 23 Nov 2005 08:26:49 -0600 From: "A. R. Van Hook" User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: sysid Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/224 X-Sequence-Number: 23475 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? thanks -- Arthur R. Van Hook Mayor The City of Lake Lotawana hook@lake-lotawana.mo.us hook@lota.us avanhook3@comcast.net (816) 578-4704 - Home (816) 578-4215 - City (816) 564-0769 - Cell