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

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Manuel Rigger <rigger(dot)manuel(at)gmail(dot)com>, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: DISCARD TEMP results in "ERROR: cache lookup failed for type 0"
Date: 2019-07-26 22:20:28
Message-ID: 20190726222028.GA18654@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 2019-Jul-05, Tom Lane wrote:

> Manuel Rigger <rigger(dot)manuel(at)gmail(dot)com> writes:
> > 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
>
> Blech. The proximate cause is fairly obvious from poking around with a

This was fixed by commit a0555ddab9b.

--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Manuel Rigger 2019-07-27 09:21:54 Multiple inheritance and ALTER TABLE issue
Previous Message Manuel Rigger 2019-07-26 22:19:52 Re: Attribute has wrong type in ALTER TABLE