StepanYankevych

SQL Error [XX000]: ERROR: cache lookup failed for type 0 with pg auto explain

2

pg 15.6 / 15.3 Citus 12.1.1 / 12.1.3 autoexplain ON test case CREATE TABLE billing.test_table ( report_id int8 NULL, date_id int4 NOT NULL); SELECT create_distributed_table('test_table', 'report_id'); CREATE OR REPLACE PROCEDURE...

False error on temp table error:42P01:46:SQL statement:relation "blahblahblah" does not exist

3

plpgsql_check version 2.7 PostgreSQL 16.2 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 11.4.1 20230605 (Red Hat 11.4.1-2), 64-bit In case temporary table is created inside the fucntion we check, it generates...