pg_group problem

Поиск
Список
Период
Сортировка
От Nigel J. Andrews
Тема pg_group problem
Дата
Msg-id Pine.LNX.4.21.0208300047460.667-100000@ponder.fairway2k.co.uk
обсуждение исходный текст
Ответы Re: pg_group problem  ("Nigel J. Andrews" <nandrews@investsystems.co.uk>)
Re: pg_group problem  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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


В списке pgsql-general по дате отправления:

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: [Pgreplication-general] Master/Slave is in town!
Следующее
От: "Nigel J. Andrews"
Дата:
Сообщение: Re: pg_group problem