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
>
