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

Sat, 28 Aug 1999 22:26:13 +0200
Spirou <spirou@carolo.net>
[Fwd: bug ? get_groname: group 0 not found]
Spirou <spirou@carolo.net> writes:
>> I can't find my classes anymore (cf below ...) !
>> 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.

Yup, that's a bug alright.  I recall having heard of these symptoms
before --- try searching the pghackers archives for mention of
'get_groname'.  I think this may be fixed in the latest release
(what version are you running, anyway?)

			regards, tom lane

Sat, 28 Aug 1999 20:49:28 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] [Fwd: bug ? get_groname: group 0 not found] 