pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jie Liang <jliang@ipinc.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-sql@postgresql.org
Subject: sysfile cruptted?
Date: Mon, 26 Feb 2001 11:57:01 -0800 (PST)
Message-ID: <Pine.BSF.4.10.10102261153370.2479-100000@tidal.ipinc.com> (raw)
In-Reply-To: <12092.982789481@sss.pgh.pa.us>


Tom,

I even cannot drop a user also,
urldb=# drop user sarah;
ERROR:  DROP USER: group "manager" does not exist
urldb=# 
urldb=# select * from pg_group;
   groname   | grosysid |              grolist               
-------------+----------+------------------------------------
 manager     |        5 | {1041,45,21}
 engineering |        3 | {1041,1042,21,23,42,22}
 generic     |        4 | {1009,1044,36,1045,1043}
 analysts    |        2 | {1048,1015,1004,1012,1014,45,1047}
urldb=# select * from pg_user where usename='sarah';
 usename | usesysid | usecreatedb | usetrace | usesuper | usecatupd |
passwd  | valuntil 
---------+----------+-------------+----------+----------+-----------+----------+----------
 sarah   |     1047 | f           | f        | f        | f         |
******** | 

but user sarah is not a memeber of manager at all!!

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
> 




Message-ID: <Pine.BSF.4.10.10102261153370.2479-100000@tidal.ipinc.com>
Permalink:  ../Pine.BSF.4.10.10102261153370.2479-100000@tidal.ipinc.com/
Also on:    postgresql.org/message-id/Pine.BSF.4.10.10102261153370.2479-100000@tidal.ipinc.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: jliang@ipinc.com, tgl@sss.pgh.pa.us
  Subject: Re: sysfile cruptted?
  In-Reply-To: <Pine.BSF.4.10.10102261153370.2479-100000@tidal.ipinc.com>
  References: <12092.982789481@sss.pgh.pa.us> <Pine.BSF.4.10.10102261153370.2479-100000@tidal.ipinc.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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