Received: from innocence.interface-business.de
	(innocence.interface-business.de [193.101.57.202])
	by hub.org (8.9.3/8.9.3) with ESMTP id FAA52341
	for <pgsql-interfaces@postgreSQL.org>;
	Thu, 2 Sep 1999 05:18:54 -0400 (EDT)
	(envelope-from gerald@mauz.interface-business.de)
Received: from mauz.interface-business.de (mauz.interface-business.de
	[193.101.57.233])
	by innocence.interface-business.de with ESMTP id LAA10433;
	Thu, 2 Sep 1999 11:18:52 +0200 (CEST)
Received: (from gerald@localhost)
	by mauz.interface-business.de (8.8.8/8.8.8) id LAA13419;
	Thu, 2 Sep 1999 11:18:52 +0200 (CEST) (envelope-from gerald)
Message-ID: <XFMail.990902111851.postgres@taifun.interface-business.de>
X-Mailer: XFMail 1.3 [p0] on FreeBSD
X-Priority: 3 (Normal)
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
MIME-Version: 1.0
In-Reply-To: <37C80E65.FCA2D284@carolo.net>
Date: Thu, 02 Sep 1999 11:18:51 +0200 (CEST)
Reply-To: gerald@interface-business.de
Organization: Interface Business
Sender: gerald@mauz.interface-business.de
From: postgres@taifun.interface-business.de
To: Spirou <spirou@carolo.net>
Subject: RE: [INTERFACES] [Fwd: bug ? get_groname: group 0 not found]
Cc: pgsql-hackers <pgsql-interfaces@postgreSQL.org>

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