Postgres Pro
Downloads
Home   >   mailing lists

DISCARD TEMP results in "ERROR: cache lookup failed for type 0" - Mailing list pgsql-bugs

From Manuel Rigger
Subject DISCARD TEMP results in "ERROR: cache lookup failed for type 0"
Date
Msg-id CA+u7OA4JKCPFrdrAbOs7XBiCyD61XJxeNav4LefkSmBLQ-Vobg@mail.gmail.com
Whole thread Raw
Responses Re: DISCARD TEMP results in "ERROR: cache lookup failed for type 0"  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
Hi everyone,

the test case below fails with "ERROR:  cache lookup failed for type
0", which is unexpected.

CREATE TEMP TABLE t0(c0 INT GENERATED ALWAYS AS IDENTITY) PARTITION BY
HASH((t0.c0));
VACUUM FULL;
DISCARD TEMP; -- unexpected: ERROR: cache lookup failed for type 0

The error only occurs for TEMP tables. I can reproduce it when
partitioning by HASH, RANGE, or LIST. It occurs with GENERATED BY
DEFAULT and also with GENERATED BY ALWAYS.

I found this bug on Ubuntu 11.4-1.pgdg19.04+1.

Best,
Manuel

pgsql-bugs by date:

Previous
From: "Daniel Verite"
Date:
Subject: Re: BUG #15892: URGENT: Using an ICU collation in a primary keycolumn breaks ILIKE query
Next
From: Manuel Rigger
Date:
Subject: Re: SELECT results in "ERROR: index key does not match expected index column"