pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Urgent help
3+ messages / 2 participants
[nested] [flat]

* Urgent help
@ 2001-02-26 19:50 Jie Liang <jliang@ipinc.com>
  2001-02-26 21:07 ` Re: Urgent help Jie Liang <jliang@ipinc.com>
  2001-02-27 19:01 ` Re: Urgent help Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 2 replies; 3+ messages in thread

From: Jie Liang @ 2001-02-26 19:50 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-sql


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@ipinc.com
www.stbernard.com
www.ipinc.com

On Wed, 21 Feb 2001, Tom Lane wrote:

> Jie Liang <jliang@ipinc.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
> 




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Urgent help
  2001-02-26 19:50 Urgent help Jie Liang <jliang@ipinc.com>
@ 2001-02-26 21:07 ` Jie Liang <jliang@ipinc.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Jie Liang @ 2001-02-26 21:07 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-sql; admin@postgressql.org

another weired thing is,
when I:
select * from pg_group;   
it takes about 2 minites to return, it took just a tick before,
it seems that some sys tables has been locked for a timeout.

Thanks.



Jie LIANG

St. Bernard Software
Internet Products Inc.

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

jliang@ipinc.com
www.stbernard.com
www.ipinc.com





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Urgent help
  2001-02-26 19:50 Urgent help Jie Liang <jliang@ipinc.com>
@ 2001-02-27 19:01 ` Tom Lane <tgl@sss.pgh.pa.us>
  1 sibling, 0 replies; 3+ messages in thread

From: Tom Lane @ 2001-02-27 19:01 UTC (permalink / raw)
  To: Jie Liang <jliang@ipinc.com>; +Cc: pgsql-sql

I suspect you have a group with a dangling reference to a deleted user.
What do you get from "select * from pg_user" and "select * from
pg_group" ?

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2001-02-27 19:01 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-02-26 19:50 Urgent help Jie Liang <jliang@ipinc.com>
2001-02-26 21:07 ` Jie Liang <jliang@ipinc.com>
2001-02-27 19:01 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox