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 CEEE53A49C8 for ; Fri, 5 Nov 2004 00:09:54 +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 78496-05 for ; Fri, 5 Nov 2004 00:09:50 +0000 (GMT) Received: from post5.inre.asu.edu (post5.inre.asu.edu [129.219.110.120]) by svr1.postgresql.org (Postfix) with ESMTP id 4C67A3A49D6 for ; Fri, 5 Nov 2004 00:09:52 +0000 (GMT) Received: from conversion.post5.inre.asu.edu by asu.edu (PMDF V6.1-1X6 #30769) id <0I6O00K01J087K@asu.edu> for pgsql-admin@postgresql.org; Thu, 04 Nov 2004 17:07:20 -0700 (MST) Received: from smtp.asu.edu (smtp.asu.edu [129.219.110.107]) by asu.edu (PMDF V6.1-1X6 #30769) with ESMTP id <0I6O00HHKJ08V0@asu.edu> for pgsql-admin@postgresql.org; Thu, 04 Nov 2004 17:07:20 -0700 (MST) Received: from moroni.pp.asu.edu (moroni.pp.asu.edu [129.219.69.200]) by smtp.asu.edu (8.12.10/8.12.10/asu_smtp_relay, nullclient, tcp_wrapped) with ESMTP id iA507KMC007324 for ; Thu, 04 Nov 2004 17:07:21 -0700 (MST) Received: by moroni.pp.asu.edu (Postfix, from userid 500) id 0CC74E4F; Thu, 04 Nov 2004 17:07:21 -0700 (MST) Date: Thu, 04 Nov 2004 17:07:20 -0700 From: David Bear Subject: pulling my hair out.. To: pgsql-admin@postgresql.org Reply-To: David.Bear@asu.edu Message-id: <20041105000720.GK30626@asu.edu> MIME-version: 1.0 Content-type: text/plain; charset=us-ascii Content-disposition: inline User-Agent: Mutt/1.4.1i 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/35 X-Sequence-Number: 15420 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 know I'm missing something simple... but would appreciate any help on this.. clearly, the table 'contactNames' does exist. I am using psql to do this. -- David Bear phone: 480-965-8257 fax: 480-965-9189 College of Public Programs/ASU Wilson Hall 232 Tempe, AZ 85287-0803 "Beware the IP portfolio, everyone will be suspect of trespassing"