Re: Roles - SET ROLE Updated - Mailing list pgsql-patches

From Stephen Frost
Subject Re: Roles - SET ROLE Updated
Date
Msg-id 20050721192826.GC24207@ns.snowman.net
Whole thread Raw
In response to Re: Roles - SET ROLE Updated  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Roles - SET ROLE Updated  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Roles - SET ROLE Updated  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
* Tom Lane (tgl@sss.pgh.pa.us) wrote:
> BTW, I realized we do not support granting roles to PUBLIC:
>
> regression=# create role r;
> CREATE ROLE
> regression=# grant r to public;
> ERROR:  role "public" does not exist
>
> but as far as I can tell SQL99 expects this to work.

Indeed, I believe you're correct, sorry about missing that.

    Stephen

Attachment

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: Roles - SET ROLE Updated
Next
From: Tom Lane
Date:
Subject: Re: Roles - SET ROLE Updated