From: Tom Lane <tgl@sss.pgh.pa.us>
To: Eric Marsden <eric.marsden@risk-engineering.org>
cc: pgsql-bugs@lists.postgresql.org
Subject: Re: Cache lookup failed for type 34813 (CREATE TYPE AS ENUM + P/B/E
 insert, processor-specific)
In-reply-to: <2dcacb45-81c9-4c38-aa36-70e2dc8df487@risk-engineering.org>
References: <2dcacb45-81c9-4c38-aa36-70e2dc8df487@risk-engineering.org>
Comments: In-reply-to Eric Marsden <eric.marsden@risk-engineering.org>
	message dated "Fri, 21 Jun 2024 16:02:48 +0200"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <595886.1718984150.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Fri, 21 Jun 2024 11:35:50 -0400
Message-ID: <595887.1718984150@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/595887.1718984150%40sss.pgh.pa.us>
Precedence: bulk

Eric Marsden <eric.marsden@risk-engineering.org> writes:
> I see a PostgreSQL error "cache lookup failed for type 34813" after the =

> following sequence of network requests over a single network connection =

> to PostgreSQL (which is otherwise idle):

> CREATE TYPE rating AS ENUM('ungood', 'good')
> CREATE TABLE act(name TEXT, value RATING)
> INSERT INTO act VALUES('thoughtcrime', 'ungood') -- OK
> INSERT INTO act VALUES('blackwhite', $1) -- with $1 =3D "good" / type oi=
d for "rating" / text format

Interesting.  To clarify, are these commands run within a single
transaction, and if not where are the transaction boundaries?

Would you run this under log_error_verbosity =3D verbose and post the
full postmaster log entry for the failure, especially the LOCATION
data?  (Even better would be a stack trace from the errfinish call,
but perhaps LOCATION will be enough.)

			regards, tom lane