Urgent help

Tom,

I think one of system file has been crupted.
I tried to drop some user then db is hangged there forever,
so kill that session, when I relogin and type
urldb=# \z categories
NOTICE: get_groname: group 2 not found
The connection to the server was lost. Attempting reset: Failed.
!#

and new user added cannot retrive data from any table.
what I can do??

Jie LIANG

St. Bernard Software
Internet Products Inc.

10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873

jliang(at)ipinc(dot)com
www.stbernard.com
www.ipinc.com

On Wed, 21 Feb 2001, Tom Lane wrote:

> Jie Liang <jliang(at)ipinc(dot)com> writes:
> > My choice:
> > if involving a lot of regular expressions, pl/Perl is better;
> > if involving a lot of SQLs or other functions(or store procedures),
> > then pl/pgsql is better.
>
> Also consider pltcl, which has pretty nearly perl-equivalent regexp
> support, and can do queries too. Besides which it's easier to build/
> install than plperl.
>
> It's a shame that plperl doesn't yet have support for making queries.
> It hasn't really progressed much past the proof-of-concept stage IMHO,
> but no one is working on it :-(
>
> regards, tom lane
>