Thread: [Fwd: bug ? get_groname: group 0 not found]

I posted this message in pgsql-novice, but got no answer.
I dare forward it to pgsql-hackers, though I fear it could be a misuse
of that list.

Could you post an answer on novice since I've not subscribed to hackers.
(Too high level for me, I think)

Spirou wrote:
> 
> I can't find my classes anymore (cf below ...) !
> 
> I send you a few SQL commands, you'll understand what I mean :
> 
> ---------------------------
> INSERT INTO pg_group VALUES ('http_user')
> CREATE USER "www-data" IN GROUP http_user;
> CREATE USER nobody IN GROUP http_user;
> 
> mybase=> select * from pg_group;
> groname  |grosysid|grolist
> ---------+--------+-------
> http_user|        |
> (1 row)
> 
> mybase=> \z
> NOTICE:  get_groname: group 0 not found
> pqReadData() -- backend closed the channel unexpectedly.
>         This probably means the backend terminated abnormally
>         before or while processing the request.
> 
> mybase=> select * from pg_class;
> NOTICE:  get_groname: group 0 not found
> pqReadData() -- backend closed the channel unexpectedly.
>         This probably means the backend terminated abnormally
>         before or while processing the request.
> We have lost the connection to the backend, so further processing is
> impossible.  Terminating.
> 
> ----------------------------
> 
> Perhaps is it worth to mention I had created a first group,
> whose name was 'http' then I deleted this one and created
> the new one called 'http_user'.
> 
> Is it a bug or a bad use ?
> Could you tell what you think of it ?
> 
> Thanks
> 

-- 
Spirou

Spirou,

>> ---------------------------
>> INSERT INTO pg_group VALUES ('http_user')
>> CREATE USER "www-data" IN GROUP http_user;
>> CREATE USER nobody IN GROUP http_user;
>> 
>> mybase=> select * from pg_group;
>> groname  |grosysid|grolist
>> ---------+--------+-------
>> http_user|        |
>> (1 row)
>> 
>> mybase=> \z
>> NOTICE:  get_groname: group 0 not found
>> pqReadData() -- backend closed the channel unexpectedly.
>>         This probably means the backend terminated abnormally
>>         before or while processing the request.

Please look at my answer for Wim Aarts question "can grolist in pg_group be
updated" in the GENERAL list. There you can found an URL for an administration
tool which handles the group access for you.

Gerald

Spirou,

>> ---------------------------
>> INSERT INTO pg_group VALUES ('http_user')
>> CREATE USER "www-data" IN GROUP http_user;
>> CREATE USER nobody IN GROUP http_user;
>> 
>> mybase=> select * from pg_group;
>> groname  |grosysid|grolist
>> ---------+--------+-------
>> http_user|        |
>> (1 row)
>> 
>> mybase=> \z
>> NOTICE:  get_groname: group 0 not found
>> pqReadData() -- backend closed the channel unexpectedly.
>>         This probably means the backend terminated abnormally
>>         before or while processing the request.

Please look at my answer for Wim Aarts question "can grolist in pg_group be
updated" in the GENERAL list. There you can found an URL for an administration
tool which handles the group access for you.

Gerald