From: | "crystal" <crystal_lium(at)163(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #4289: drop owned by report ERROR: cache lookup failed for relation 16390 |
Date: | 2008-07-09 08:11:30 |
Message-ID: | 200807090811.m698BUrc039626@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 4289
Logged by: crystal
Email address: crystal_lium(at)163(dot)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)
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2008-07-09 13:55:22 | Re: BUG #4289: drop owned by report ERROR: cache lookup failed for relation 16390 |
Previous Message | Simon Riggs | 2008-07-08 14:24:07 | Re: BUG #4276: Feature request aggregate indexes |