Re: [HACKERS] grant still broken

On Tue, 13 Jan 1998, Bruce Momjian wrote:

> Gee, still works fine here under bsd/os 3.0.
>
>     #$ sql test
>     Welcome to the POSTGRESQL interactive sql monitor:
>       Please read the file COPYRIGHT for copyright terms of POSTGRESQL
>
>        type \? for help on slash commands
>        type \q to quit
>        type \g or terminate with semicolon to execute query
>      You are currently connected to the database: test
>
>     test=> create table a (id int4,url text);
>     CREATE
>     test=> insert into a values (1,'http://www.demon.co.uk/finder');
>     INSERT 143530 1
>     test=> grant all on a to public;
>     CHANGE
>     test=>

FreeBSD 3.0-CURRENT as of yesterday:

scrappy=> create table a (id int4,url text);
CREATE
scrappy=> insert into a values (1,'http://www.demon.co.uk/finder');
INSERT 143210 1
scrappy=> grant all on a to public;
CHANGE
scrappy=> \z

Database    = scrappy
 +------------------+----------------------------------------------------+
 |  Relation        |             Grant/Revoke Permissions               |
 +------------------+----------------------------------------------------+
 | a                | {"=arwR"}                                          |
 | testtable        |                                                    |
 +------------------+----------------------------------------------------+
scrappy=>

Marc G. Fournier
Systems Administrator @ hub.org
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org