Received: from neptun.sns-felb.debis.de (neptun.sns-felb.debis.de [53.122.101.2]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id eAT6vdt09892 for ; Wed, 29 Nov 2000 01:57:39 -0500 (EST) (envelope-from jhartwig@debis.com) Received: by neptun.sns-felb.debis.de; id IAA21677; Wed, 29 Nov 2000 08:01:56 +0100 Received: from unknown(53.113.82.10) by neptun.sns-felb.debis.de via smap (V5.0) id xma021437; Wed, 29 Nov 00 08:01:19 +0100 Received: from mail1.b3.dsh.de (localhost [127.0.0.1]) by dshmail1.dsh.de (8.9.1/8.8.7) with ESMTP id HAA04988; Wed, 29 Nov 2000 07:56:55 +0100 (MET) Received: from debis.com ([138.201.143.121]) by mail1.b3.dsh.de (8.10.0/8.10.0) with ESMTP id eAT6Igh04434; Wed, 29 Nov 2000 07:18:42 +0100 Message-ID: <3A249FBD.F99C5C0C@debis.com> Date: Wed, 29 Nov 2000 07:18:37 +0100 From: Jens Hartwig Organization: debis Systemhaus GEI X-Mailer: Mozilla 4.7 [de] (WinNT; I) X-Accept-Language: de MIME-Version: 1.0 To: Tom Lane CC: pgsql-sql@postgresql.org Subject: Re: Damaged table "pg_access" References: <3A2366CE.5FB828E@debis.com> <14900.975423998@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200011/271 X-Sequence-Number: 302 Hello, yes, you were completely right, thank you very much, you saved me from spending much time on this problem! The recreation of the groups 1, 2, 3 and 4 resolved the problem :-) My next question is: how can I (as a workaround till version 7.1) permanently remove a group without facing this problem? Can I rudely remove the granted permissions by any command (e.g. deleting it manually from the system catalogue)? Best regards, Jens Tom Lane schrieb: > > Jens Hartwig writes: > > when I try to access the system-table "pg_class", I get the following > > error: > > > zeda=# select * from pg_class; > > NOTICE: get_groname: group 1 not found > > pqReadData() -- backend closed the channel unexpectedly. > > Evidently you had created a group with sysid 1, granted some permissions > on some table to that group, and then deleted the group. Re-create the > group (CREATE GROUP foo WITH SYSID 1). > > I thought the crash in this situation had been fixed long since, but > apparently not :-( ... it still fails in current sources. I'll make > sure it's fixed for 7.1. > > regards, tom lane ============================================= Jens Hartwig --------------------------------------------- debis Systemhaus GEI mbH 10875 Berlin Tel. : +49 (0)30 2554-3282 Fax : +49 (0)30 2554-3187 Mobil : +49 (0)170 167-2648 E-Mail : jhartwig@debis.com =============================================