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 5BEA1DADAE for ; Wed, 23 Nov 2005 12:31:11 -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 33050-02 for ; Wed, 23 Nov 2005 16:31:09 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mx1.surnet.cl (mx1.surnet.cl [216.155.73.180]) by svr1.postgresql.org (Postfix) with ESMTP id 9950FD7AD7 for ; Wed, 23 Nov 2005 12:31:06 -0400 (AST) Received: from unknown (HELO cluster.surnet.cl) ([216.155.73.165]) by mx1.surnet.cl with ESMTP; 23 Nov 2005 12:47:32 -0300 X-IronPort-AV: i="3.97,364,1125892800"; d="scan'208"; a="31317733:sNHT8257498238" Received: from alvh.no-ip.org (200.85.218.89) by cluster.surnet.cl (7.0.043) (authenticated as alvherre@surnet.cl) id 43501597005571DD; Wed, 23 Nov 2005 12:45:18 -0300 Received: by alvh.no-ip.org (Postfix, from userid 1000) id BC178C30B0D; Wed, 23 Nov 2005 12:45:22 -0300 (CLST) Date: Wed, 23 Nov 2005 12:45:22 -0300 From: Alvaro Herrera To: "A. R. Van Hook" Cc: pgsql-sql@postgresql.org Subject: Re: sysid Message-ID: <20051123154522.GC26927@surnet.cl> Mail-Followup-To: "A. R. Van Hook" , pgsql-sql@postgresql.org References: <43847C29.8050800@lake-lotawana.mo.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <43847C29.8050800@lake-lotawana.mo.us> User-Agent: Mutt/1.5.11 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=3.502 required=5 tests=[AWL=-0.567, DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_POST=1.44, RCVD_IN_NJABL_PROXY=0.327, RCVD_IN_SORBS_SOCKS=1.823] X-Spam-Score: 3.502 X-Spam-Level: *** X-Archive-Number: 200511/226 X-Sequence-Number: 23477 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. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support