Hello,

    I'm using  PostgreSQL -6.4.2 on the Linux Red Hat 5.2. Via psql,
I've created a group in the table pg_group to facilitate grant to all
users in this group. But it seems the grant to group interrupt the
backend connection. Please help.

First : psql => \z                 (allowed to see the grant/revoke
permissions, which is empty )
                    =>  INSERT INTO pg_group VALUES ('labo');
                                insert
                    =>  CREATE USER tom in GROUP labo;
                                create
                    =>  GRANT SELECT ON projects  TO GROUP labo;
                                change
 then
                    => \z
            pqReadData() -- backend closed the channel unexpectedly.
            This probably means the backend terminated abnormally before
or while processing the request.

.... And I need to destroy the db and load up the backup version.

By the way, in which table can I see who belongs to a group ?

Thanks in advance,
    Nuch

Reply via email to