BUG #14867: Cascade drop type error

From: gomer94(at)yandex(dot)ru
To: pgsql-bugs(at)postgresql(dot)org
Cc: gomer94(at)yandex(dot)ru
Subject: BUG #14867: Cascade drop type error
Date: 2017-10-23 15:01:18
Message-ID: 20171023150118.1477.19174@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 14867
Logged by: Mansur Galiev
Email address: gomer94(at)yandex(dot)ru
PostgreSQL version: 10.0
Operating system: Ubuntu 16.04.3 LTS x64
Description:

CREATE TYPE my_type AS (f1 integer);
CREATE TYPE my_type_2 AS (f2 my_type);
CREATE TABLE my_table (c1 my_type_2);
CREATE VIEW my_view AS SELECT ((C1).f2).f1 FROM my_table;
DROP TYPE my_type CASCADE;

after then my_view still has a column and a type queries of this:

SELECT * FROM pg_views;

shows:

ERROR: could not open relation with OID 33070

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2017-10-23 16:09:24 Re: BUG #14867: Cascade drop type error
Previous Message Reinier Haasjes 2017-10-23 14:12:46 Re: [pg_dump] not dumping some default privileges