Received: from mx.mx.skynet.be (mxrelay.skynet.be [195.238.1.11]) by hub.org (8.9.3/8.9.3) with ESMTP id MAA76361 for ; Sat, 28 Aug 1999 12:30:22 -0400 (EDT) (envelope-from spirou@carolo.net) Received: from carolo.net (dialup169.wavre.skynet.be [195.238.10.169]) by mx.mx.skynet.be (8.9.1/8.9.1) with ESMTP id SAA00528 for ; Sat, 28 Aug 1999 18:30:19 +0200 (MET DST) Sender: spirou@mx.mx.skynet.be Message-ID: <37C80E65.FCA2D284@carolo.net> Date: Sat, 28 Aug 1999 18:29:25 +0200 From: Spirou Reply-To: spirou@carolo.net Organization: COLnet X-Mailer: Mozilla 4.5 [en] (X11; I; Linux 2.2.9 i586) X-Accept-Language: fr, en, nl MIME-Version: 1.0 To: pgsql-hackers Subject: [Fwd: bug ? get_groname: group 0 not found] Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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