SPR-944: Issue when querying the user_types table after adding an ENUM type

[garthgoodson]

field	value
url	https://linear.app/springtail/issue/SPR-944/issue-when-querying-the-user-types-table-after-adding-an-enum-type
author	@
date	Wed Aug 13 06:42:45 PDT 2025
state	Backlog
project
priority	High
assignee
labels	Bug
related
parent
children
PRs
attachments

After creating an enum type, querying the user_types table is failing

SQL

CREATE TYPE numbers AS ENUM ('one', 'two', 'three');
CREATE TABLE nums (
    id SERIAL PRIMARY KEY,
    number numbers
);

Stack Trace:

[2025-08-13 10:59:58.987 +00:00] [debug] [pg_fdw_mgr.cc:546:fdw_create_state] [thread 20158] fdw_create_state: db_id: 1, tid: 8, xid: 8, pg_xid: 10154821, schema_xid: 8
[2025-08-13 10:59:58.988 +00:00] [debug] [pg_fdw_mgr.cc:1076:fdw_get_path_keys] [thread 20158] fdw_get_path_keys
[2025-08-13 10:59:58.988 +00:00] [debug] [pg_fdw_mgr.cc:559:fdw_begin_scan] [thread 20158] fdw_begin_scan: tid: 8, 8
[2025-08-13 10:59:58.988 +00:00] [debug] [pg_fdw_mgr.cc:619:fdw_begin_scan] [thread 20158] Target list column: 1:type_id
[2025-08-13 10:59:58.988 +00:00] [debug] [pg_fdw_mgr.cc:619:fdw_begin_scan] [thread 20158] Target list column: 2:namespace_id
[2025-08-13 10:59:58.988 +00:00] [debug] [pg_fdw_mgr.cc:619:fdw_begin_scan] [thread 20158] Target list column: 3:name
[2025-08-13 10:59:58.988 +00:00] [debug] [pg_fdw_mgr.cc:619:fdw_begin_scan] [thread 20158] Target list column: 4:value
[2025-08-13 10:59:58.988 +00:00] [debug] [pg_fdw_mgr.cc:619:fdw_begin_scan] [thread 20158] Target list column: 5:xid
[2025-08-13 10:59:58.988 +00:00] [debug] [pg_fdw_mgr.cc:619:fdw_begin_scan] [thread 20158] Target list column: 6:lsn
[2025-08-13 10:59:58.988 +00:00] [debug] [pg_fdw_mgr.cc:619:fdw_begin_scan] [thread 20158] Target list column: 7:type
[2025-08-13 10:59:58.988 +00:00] [debug] [pg_fdw_mgr.cc:619:fdw_begin_scan] [thread 20158] Target list column: 8:exists
[2025-08-13 10:59:58.988 +00:00] [debug] [pg_fdw_mgr.cc:678:_set_scan_iterators] [thread 20158] Setting up iterators for full table scan: tid=8, ASC=true, quals=0
[2025-08-13 10:59:58.988 +00:00] [debug] [pg_fdw_mgr.cc:853:fdw_iterate_scan] [thread 20158] fdw_iterate_scan: tid: 8
[2025-08-13 10:59:58.988 +00:00] [debug] [pg_fdw_mgr.cc:925:fdw_iterate_scan] [thread 20158] Fetching column: 1
[2025-08-13 10:59:58.988 +00:00] [debug] [pg_fdw_mgr.cc:925:fdw_iterate_scan] [thread 20158] Fetching column: 2
[2025-08-13 10:59:58.988 +00:00] [debug] [pg_fdw_mgr.cc:925:fdw_iterate_scan] [thread 20158] Fetching column: 3
[2025-08-13 10:59:58.988 +00:00] [debug] [pg_fdw_mgr.cc:925:fdw_iterate_scan] [thread 20158] Fetching column: 4
[2025-08-13 10:59:58.988 +00:00] [debug] [pg_fdw_mgr.cc:925:fdw_iterate_scan] [thread 20158] Fetching column: 5
[2025-08-13 10:59:58.988 +00:00] [debug] [pg_fdw_mgr.cc:925:fdw_iterate_scan] [thread 20158] Fetching column: 6
[2025-08-13 10:59:58.988 +00:00] [debug] [pg_fdw_mgr.cc:925:fdw_iterate_scan] [thread 20158] Fetching column: 7
[2025-08-13 10:59:58.988 +00:00] [debug] [pg_fdw_mgr.cc:925:fdw_iterate_scan] [thread 20158] Fetching column: 8
[2025-08-13 10:59:58.989 +00:00] [error] [exception.cc:10:backtrace_handler] [thread 20158] Crash detected from signal 11
[2025-08-13 10:59:59.278 +00:00] [error] [exception.cc:24:backtrace_handler] [thread 20158] Backtrace from signal 11:
Stack trace (most recent call first):
#0  0x0000ffff92fd1963 in backtrace_handler at /home/dev/springtail/src/common/exception.cc:19:47
#1  0x0000ffffa0b9879f at linux-vdso.so.1
#2  0x0000aaaad8de44b0 at /usr/lib/postgresql/16/bin/postgres
#3  0x0000aaaad8894247 at /usr/lib/postgresql/16/bin/postgres
#4  0x0000aaaad8aa2e87 at /usr/lib/postgresql/16/bin/postgres
#5  0x0000aaaad8c9bc1f at /usr/lib/postgresql/16/bin/postgres
#6  0x0000aaaad8c9d7cb at /usr/lib/postgresql/16/bin/postgres
#7  0x0000aaaad8c954ef at /usr/lib/postgresql/16/bin/postgres
#8  0x0000aaaad8c9652b at /usr/lib/postgresql/16/bin/postgres
#9  0x0000aaaad8ea38bb at /usr/lib/postgresql/16/bin/postgres
#10 0x0000aaaad8bf1b0b at /usr/lib/postgresql/16/bin/postgres
#11 0x0000aaaad887e517 at /usr/lib/postgresql/16/bin/postgres
#12 0x0000ffff9f4684c3 in __libc_start_call_main at ./csu/../sysdeps/nptl/libc_start_call_main.h:58:16
#13 0x0000ffff9f468597 in __libc_start_main_impl at ./csu/../csu/libc-start.c:360:3
#14 0x0000aaaad887ea6f at /usr/lib/postgresql/16/bin/postgres