pg_group problem

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

Responses

Browse pgsql-general by date

  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 ?