Re: BUG #19084: dump/restore table doesn't work with GENARETED column and custom type and cast in function
От
David G. Johnston
Тема
Re: BUG #19084: dump/restore table doesn't work with GENARETED column and custom type and cast in function
Дата
Msg-id
CAKFQuwb08rC541j4ibPEuF5SPx90FTOX5Q3DjmknmL4ybSMGTg@mail.gmail.com
Ответ на
BUG #19084: dump/restore table doesn't work with GENARETED column and custom type and cast in function (PG Bug reporting form)
Список
Дерево обсуждения
BUG #19084: dump/restore table doesn't work with GENARETED column and custom type and cast in function PG Bug reporting form <noreply@postgresql.org>
Re: BUG #19084: dump/restore table doesn't work with GENARETED column and custom type and cast in function Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #19084: dump/restore table doesn't work with GENARETED column and custom type and cast in function "David G. Johnston" <david.g.johnston@gmail.com>
On Mon, Oct 13, 2025, 10:38 PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:
Bug reference: 19084
Logged by: David Turoň
Email address: turon.david@seznam.cz
PostgreSQL version: 17.6
Operating system: AlmaLinux release 9.0
Description:
pg_restore: error: could not execute query: ERROR: type "test_type" does
not exist
LINE 1: SELECT array_agg((e->>'item')::test_type) FROM jsonb_array_...
This is an application bug, not Postgres. You relied on the public schema being in search_path but didn't declare that fact via SET on the function. Either use SET, or schema-qualify objects so you don't have to rely on search_path at all.
David J.
В списке pgsql-bugs по дате отправления
От: PG Bug reporting form
Дата:
От: Tom Lane
Дата:
