Message-ID: <4C11338E.6050702@obviously.com>
Date: Thu, 10 Jun 2010 11:48:46 -0700
From: Bryce Nesbitt <bryce2@obviously.com>
User-Agent: Thunderbird 2.0.0.24 (Windows/20100228)
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Returning to default (e.g. blank) table permissions after a revoke?
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

If I create a new table the "Access privileges" are blank, which gives 
implicit access to the table owner.
But if I touch the grants, then revoke, the privileges are set to {} 
which is not the same thing:

production=> create table zzz_junk1 ();

production=> \z zzz_junk1
 Schema |   Name    | Type  | Access privileges
--------+-----------+-------+-------------------
 public | zzz_junk1 | table |

production=> grant all on zzz_junk1 to production;
production=> \z zzz_junk1
         Access privileges for database "production"
 Schema |   Name    | Type  |       Access privileges
--------+-----------+-------+--------------------------------
 public | zzz_junk1 | table | {production=arwdxt/production}

production=> revoke all on zzz_junk1 from production;
production=> \z zzz_junk1
  Access privileges for database "production"
 Schema |   Name    | Type  | Access privileges
--------+-----------+-------+-------------------
 public | zzz_junk1 | table | {}


How can I return to the initial state, where the "Access privileges" are 
unspecified?
I'm using Postgres 8.3 here.  
http://www.postgresql.org/docs/8.3/static/sql-grant.html does not seem 
to cover this topic.