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 86CA0DBA1B for ; Wed, 23 Nov 2005 11:52:07 -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 22141-05-2 for ; Wed, 23 Nov 2005 15:52:11 +0000 (GMT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.197]) by svr1.postgresql.org (Postfix) with ESMTP id DDA3BDBA04 for ; Wed, 23 Nov 2005 11:52:00 -0400 (AST) Received: by zproxy.gmail.com with SMTP id o37so1618713nzf for ; Wed, 23 Nov 2005 07:52:03 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=AN6V1N8cTaBxhplg70RC/6m0jEvnHD5EKqRDI3SgNAdnzddZkpSFKZYp2ktXFZXc8/+mOW9J0x2lxPJ6Ye0QxX49V6eaAMLDcj8zvJjVLHzUBjQnx3ffLXpgwQrbx1YFH2JFgDPsVqR3aXQuGgSi1LSaYlKEce0lVle1bMN6Tfs= Received: by 10.65.206.12 with SMTP id i12mr6003953qbq; Wed, 23 Nov 2005 07:52:03 -0800 (PST) Received: by 10.65.180.2 with HTTP; Wed, 23 Nov 2005 07:52:02 -0800 (PST) Message-ID: Date: Wed, 23 Nov 2005 10:52:02 -0500 From: Jaime Casanova To: "A. R. Van Hook" Subject: Re: sysid Cc: pgsql-sql@postgresql.org In-Reply-To: <43847C29.8050800@lake-lotawana.mo.us> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <43847C29.8050800@lake-lotawana.mo.us> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.013 required=5 tests=[AWL=0.013] X-Spam-Score: 0.013 X-Spam-Level: X-Archive-Number: 200511/225 X-Sequence-Number: 23476 On 11/23/05, 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=3D# 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 > use versions < 8.1 > -- > 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 > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings > -- Atentamente, Jaime Casanova (DBA: DataBase Aniquilator ;)