GRANT role TO PUBLIC- not working? - Mailing list pgsql-novice

From Brian Hurt
Subject GRANT role TO PUBLIC- not working?
Date
Msg-id 44CFA649.7080803@janestcapital.com
Whole thread Raw
Responses Re: GRANT role TO PUBLIC- not working?  (Richard Broersma Jr <rabroersma@yahoo.com>)
Re: GRANT role TO PUBLIC- not working?  ("Nikolay Samokhvalov" <samokhvalov@gmail.com>)
List pgsql-novice
I'm having problems granting a role to PUBLIC.  According to the manual,
you do this by:
    GRANT role TO PUBLIC;

but when I try this, I get an error:

bhurt_dev=# GRANT test_role TO PUBLIC;
ERROR:  role "public" does not exist
bhurt_dev=#

This is Postgresql 8.01.0004.  Any ideas?

Brian


pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: precompiling regular expressions in plpgsql
Next
From: Richard Broersma Jr
Date:
Subject: Re: GRANT role TO PUBLIC- not working?