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