BUG #4289: drop owned by report ERROR: cache lookup failed for relation 16390

Поиск
Список
Период
Сортировка
От crystal
Тема BUG #4289: drop owned by report ERROR: cache lookup failed for relation 16390
Дата
Msg-id 200807090811.m698BUrc039626@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #4289: drop owned by report ERROR: cache lookup failed for relation 16390
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      4289
Logged by:          crystal
Email address:      crystal_lium@163.com
PostgreSQL version: 8.3.3
Operating system:   linux
Description:        drop owned by report ERROR:  cache lookup failed for
relation 16390
Details:

$ ./psql TEST
Welcome to psql 8.3.3, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

TEST=# create user u1;
CREATE ROLE
TEST=# create user u2;
CREATE ROLE
TEST=# set session authorization u1;
SET
TEST=> create table t1 (a int);
CREATE TABLE
TEST=> set session authorization u2;
SET
TEST=> create view v2 as select * from t1;
CREATE VIEW
TEST=> reset session authorization;
SET
TEST=# drop owned by u1, u2 cascade;
NOTICE:  drop cascades to view v2
ERROR:  cache lookup failed for relation 16390
TEST=# \d
       List of relations
 Schema | Name | Type  | Owner
--------+------+-------+-------
 public | t1   | table | u1
 public | v2   | view  | u2
(2 rows)

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #4286: ORDER BY returns inconsistent results when using LIMIT on a integer column set to default values
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: BUG #4289: drop owned by report ERROR: cache lookup failed for relation 16390