From: | "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | pg_group problem |
Date: | 2002-08-30 00:17:44 |
Message-ID: | Pine.LNX.4.21.0208300047460.667-100000@ponder.fairway2k.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Not sure what's going on but I have a problem using pg_group after creating a
group:
testschemas=# select * from pg_group;
groname | grosysid | grolist
---------+----------+---------
(0 rows)
testschemas=# create group testgrp_1 user foo,bar;
CREATE GROUP
testschemas=# select * from pg_group;
ERROR: cache lookup failed for type 2139062143
testschemas=# select * from pg_user;
usename | usesysid | usecreatedb | usesuper | usecatupd | passwd | valuntil | useconfig
----------+----------+-------------+----------+-----------+----------+----------+-----------
software | 1 | t | t | t | ******** | |
foo | 100 | f | f | f | ******** | |
bar | 101 | f | f | f | ******** | |
(3 rows)
testschemas=# select * from pg_group;
ERROR: cache lookup failed for type 2139062143
What's that all about?
Stopping and restarting the backend doesn't make the select of pg_group work,
unsurprisingly.
Okay, narrowed it down to adding users to a group I think. In a fresh build
and install from anoncvs:
testschemas=# create group mytest_grp;
CREATE GROUP
testschemas=# select * from pg_group;
groname | grosysid | grolist
------------+----------+---------
mytest_grp | 100 |
(1 row)
testschemas=# alter group mytest_grp add user foo;
ALTER GROUP
testschemas=# select * from pg_group;
ERROR: cache lookup failed for type 2139062143
Is this something to do with the recent changes to array_in/out perhaps?
--
Nigel J. Andrews
Director
---
Logictree Systems Limited
Computer Consultants
From | Date | Subject | |
---|---|---|---|
Next Message | Nigel J. Andrews | 2002-08-30 00:19:48 | Re: pg_group problem |
Previous Message | bearm | 2002-08-29 23:38:11 | show ? |