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