X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E3CE43A49F5 for ; Fri, 5 Nov 2004 00:46:04 +0000 (GMT) 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 86074-08 for ; Fri, 5 Nov 2004 00:45:53 +0000 (GMT) Received: from megazone.bigpanda.com (megazone.bigpanda.com [64.147.171.210]) by svr1.postgresql.org (Postfix) with ESMTP id 064303A497A for ; Fri, 5 Nov 2004 00:45:55 +0000 (GMT) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id EC17E356B9; Thu, 4 Nov 2004 16:45:52 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id EAA2D356B1; Thu, 4 Nov 2004 16:45:52 -0800 (PST) Date: Thu, 4 Nov 2004 16:45:52 -0800 (PST) From: Stephan Szabo To: David Bear Cc: pgsql-admin@postgresql.org Subject: Re: pulling my hair out.. In-Reply-To: <20041105000720.GK30626@asu.edu> Message-ID: <20041104164420.X15783@megazone.bigpanda.com> References: <20041105000720.GK30626@asu.edu> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/36 X-Sequence-Number: 15421 On Thu, 4 Nov 2004, David Bear wrote: > I'm using pg 7.3 on freebsd.. > > I've created a database use sql. > > now, as the pg superuser I cant seem to grant any permissions on the > tables in the db.. > > npcenter-# \z > Access privileges for database "npcenter" > Schema | Table | Access privileges > --------+--------------+------------------- > public | contactNames | > public | pga_diagrams | > public | pga_forms | > public | pga_graphs | > public | pga_images | > public | pga_layout | > public | pga_queries | > public | pga_reports | > public | pga_scripts | > (9 rows) > > npcenter=# grant all on table contactNames to group npcenter; > ERROR: relation "contactnames" does not exist > npcenter=# grant all on table 'contactNames' to group npcenter; > ERROR: syntax error at or near "'contactNames'" at character 20 I think you want "contactNames" to refer to the table. Doublequoted identifiers aren't casefolded.