DISCARD TEMP results in "ERROR: cache lookup failed for type 0"

Поиск
Список
Период
Сортировка
От Manuel Rigger
Тема DISCARD TEMP results in "ERROR: cache lookup failed for type 0"
Дата
Msg-id CA+u7OA4JKCPFrdrAbOs7XBiCyD61XJxeNav4LefkSmBLQ-Vobg@mail.gmail.com
обсуждение исходный текст
Ответы Re: DISCARD TEMP results in "ERROR: cache lookup failed for type 0"  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Дерево обсуждения 
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 по дате отправления:

Предыдущее
От: "Daniel Verite"
Дата:
Сообщение: Re: BUG #15892: URGENT: Using an ICU collation in a primary keycolumn breaks ILIKE query
Следующее
От: Manuel Rigger
Дата:
Сообщение: Re: SELECT results in "ERROR: index key does not match expected index column"