Thread: Error ??

Error ??

From
Tubagus Nizomi
Date:
Hello,
i have an error :

NOTICE:  get_groname: group 0 not found
getTables(): SELECT failed.  Explanation from backend: 'pqReadData() -- 
backend closed the channel unexpectedly.       This probably means the backend terminated abnormally       before or
whileprocessing the request.
 

what can i do ??
help me please

Nizomi 

----------

PostgreSQL 6.5.3 on sparc-sun-solaris2.6, compiled by gcc 2.95.1


Re: Error ??

From
Tom Lane
Date:
Tubagus Nizomi <nizomi@dnet.net.id> writes:
> NOTICE:  get_groname: group 0 not found
> getTables(): SELECT failed.  Explanation from backend: 'pqReadData() -- 
> backend closed the channel unexpectedly.

I think you dropped a user that was still a member of a group, or
a group still referred to in a table's permissions, or something
like that.  Look into pg_user and pg_group, and look at the permissions
of the table you were trying to access.

We have fixed a couple of bugs like this in current sources, but I'd
like to know the details when you have them, just to make sure this
case is covered now ...
        regards, tom lane