PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID15718
PG Version11.2
OSAll Linux
Opened2019-03-28 13:19:02+00
Reported byAlex
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      15718
Logged by:          Alex
Email address:      (redacted)
PostgreSQL version: 11.2
Operating system:   All Linux
Description:        

Code to replicate the issue:
https://pastebin.com/rc8q35Qj

This happened to our ETL processes that re-create the staging data on each
run. Enums are defining partition keys for some tables, that then flow into
tables in another schema. When the schema containing that enum gets dropped,
the columns that use it are also dropped. If those columns are also
partition keys, it ends up in a situation where it's not possible to drop
the parent table. Failure with ERROR: cache lookup failed for type 0.

Issue has been observed at least since Postgresql 10, but just got
successfully replicated on minimal code.

Messages

DateAuthorSubject
2019-03-28 13:19:02+00PG Bug reporting formBUG #15718: DROP TABLE fails if it's partitioned by a key of a deleted enum
2019-03-28 17:04:13+00Alvaro HerreraRe: BUG #15718: DROP TABLE fails if it's partitioned by a key of a deleted enum
2019-03-28 17:19:17+00Alexandru PisarencoRe: BUG #15718: DROP TABLE fails if it's partitioned by a key of a deleted enum