Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M44576=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1ZhLAO-0005aa-Py
 for pgsql-admin@arkaria.postgresql.org; Wed, 30 Sep 2015 17:27:44 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.84) (envelope-from
 <pgsql-admin-owner+M44576=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1ZhLAO-00070A-C9
 for pgsql-admin@arkaria.postgresql.org; Wed, 30 Sep 2015 17:27:44 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
 (Exim 4.84) (envelope-from <korry.douglas@enterprisedb.com>)
 id 1ZhL8k-0003qh-Tv
 for pgsql-admin@postgresql.org; Wed, 30 Sep 2015 17:26:02 +0000
Received: from mail-qg0-f43.google.com ([209.85.192.43])
 by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
 (Exim 4.84) (envelope-from <korry.douglas@enterprisedb.com>)
 id 1ZhL8d-0003ei-NU
 for pgsql-admin@postgresql.org; Wed, 30 Sep 2015 17:26:02 +0000
Received: by qgt47 with SMTP id 47so41520965qgt.2
 for <pgsql-admin@postgresql.org>; Wed, 30 Sep 2015 10:25:53 -0700 (PDT)
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
 d=1e100.net; s=20130820;
 h=x-gm-message-state:message-id:date:from:user-agent:mime-version:to
 :cc:subject:references:in-reply-to:content-type
 :content-transfer-encoding;
 bh=KR2CsyNkb7iyiOndWNjPu9CdS27C/KIQVGMH+D/8klU=;
 b=e6nDyE7LcvChRP3BByaoqAhYsCResPggl2J/ND+85nkXc2TkCdm7CdDFVyFwWo1sMc
 5HjuHNDfurdKMTOeCz7eQP0UFAd6McreermrIjiey/w1VxGDMEFd4YVlFAzcJBSk0fJV
 grzAnGAhnpsVz6WqnesjDZoEU1QJ0UR9Ijaw/yoL/m9cRlYNIBCpgMwpRxOlNb+Wr3Jo
 1GmkdLBGUYaZ2+ERBO8doU8lDS5qWDPUQdrGP0GnviTDdjkbQpHcskjDZJ6iHaT5Iylh
 zH0wuy6JQB7YpIJO4WAhICvyK2XrbPY32m0sQl9Uz3PqLrnGi0Il/oYnYOasZajcrb45
 XBng==
X-Gm-Message-State: 
 ALoCoQkua0cu4KBJjCwQca4KpBiOifirFbftB6bpn31Oz3KFiekMJUuzH2iEvFKCtppNOc8TL7aw
X-Received: by 10.140.236.203 with SMTP id h194mr5890549qhc.73.1443633953793;
 Wed, 30 Sep 2015 10:25:53 -0700 (PDT)
Received: from MegaMac.local (va-76-4-65-131.sta.embarqhsd.net. [76.4.65.131])
 by smtp.gmail.com with ESMTPSA id
 b73sm640098qka.14.2015.09.30.10.25.51
 (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128);
 Wed, 30 Sep 2015 10:25:52 -0700 (PDT)
Message-ID: <560C1AC5.7040401@enterprisedb.com>
Date: Wed, 30 Sep 2015 13:24:21 -0400
From: Korry Douglas <korry.douglas@enterprisedb.com>
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9;
 rv:17.0) Gecko/20130509 Thunderbird/17.0.6
MIME-Version: 1.0
To: John Scalia <jayknowsunix@gmail.com>
CC: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Re: Adding group role to a user
References: 
 <CABzCKRCmO6A+8y+dpneX6KwShmw0mFDkK4bAG+vVxnYaGz0A2Q@mail.gmail.com>
In-Reply-To: 
 <CABzCKRCmO6A+8y+dpneX6KwShmw0mFDkK4bAG+vVxnYaGz0A2Q@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -2.6 (--)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org


ALTER GROUP "schema-rw" ADD USER someuser.


                 -- Korry

> Someone here in their infinite wisdom decided that all our group names 
> would contain a "-". Thus, all the groups look like "schema-ro" or 
> "schema-rw", My problem is that neither a "grant <group-name> to 
> <user>;" nor a "alter group <group-name> add user <user>" will work 
> properly as the command interpreter doesn't like the group name having 
> a "-" in it.
>
> So, I'm looking for a work-around up to and including directly 
> altering the pg_auth table. Any ideas?
> --
> Jay



-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin