X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id C5F2E9DC84D for ; Sat, 21 Jan 2006 13:54:36 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 10852-08 for ; Sat, 21 Jan 2006 13:54:36 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 73C229DC806 for ; Sat, 21 Jan 2006 13:54:34 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id k0LHsYPo018533; Sat, 21 Jan 2006 12:54:34 -0500 (EST) To: Stijn De Weirdt cc: pgsql-admin@postgresql.org Subject: Re: alter role In-reply-to: <20060121114836.C7E7C8D07@mach.vub.ac.be> References: <20060121114836.C7E7C8D07@mach.vub.ac.be> Comments: In-reply-to Stijn De Weirdt message dated "Sat, 21 Jan 2006 12:48:36 +0100" Date: Sat, 21 Jan 2006 12:54:34 -0500 Message-ID: <18532.1137866074@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.095 required=5 tests=[AWL=0.095] X-Spam-Score: 0.095 X-Spam-Level: X-Archive-Number: 200601/254 X-Sequence-Number: 20342 Stijn De Weirdt writes: > i am looking for a way to list the attributes for a given role. i looked into the docs but didn't find anything directly usable. Look at the queries issued by psql for "\du" > on a related problem, what actually happens when you issue a > "ALTER ROLE someone SOME_ATTRIBUTES" if that user is connected to the db? > (ie when do the changes happen and (for me more intersting) does something happen at all when the attributes are the same as the current ones?) AFAIR, those changes will propagate when you commit, or at worst at the user's next transaction start. I'm not sure if that code tries to optimize out no-op catalog updates ... look in backend/commands/user.c to find out. regards, tom lane