Received: from tidal.ipinc.com (tidal.ipinc.com [199.245.188.85]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1QJvXx26397 for ; Mon, 26 Feb 2001 14:57:33 -0500 (EST) (envelope-from jliang@tidal.ipinc.com) Received: from localhost (jliang@localhost) by tidal.ipinc.com (8.9.3/8.9.3) with ESMTP id LAA03479; Mon, 26 Feb 2001 11:57:01 -0800 (PST) (envelope-from jliang@tidal.ipinc.com) Date: Mon, 26 Feb 2001 11:57:01 -0800 (PST) From: Jie Liang To: Tom Lane cc: pgsql-sql@postgresql.org Subject: sysfile cruptted? In-Reply-To: <12092.982789481@sss.pgh.pa.us> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200102/407 X-Sequence-Number: 1612 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 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 >