Re: [HACKERS] grant still broken

>
> Well, I've rebuilt postgres again, using a fresh cvs snapshot, and grant
> is still broken.
>
> Infact, it gets worse. Once you try to use the grant statement, then any
> other connection that was active at that time - even on different
> databases, will die with the same message, hinting it may be something in
> shared memory that's breaking.
>
> Heres the output of psql, first as user postgres:
>
> [postgres@maidast pgsql]$ psql -h localhost db1
> 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: db1
>
> db1=> create table a (id int4,url text);
> CREATE
> db1=> insert into a values (1,'http://www.demon.co.uk/finder');
> INSERT 18250 1
> db1=> grant all on a to public;
> PQexec() -- Request was sent to backend, but backend closed the channel
> before responding.
>         This probably means the backend terminated abnormally before or
> while processing the request.

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=>


--
Bruce Momjian
maillist@candle.pha.pa.us