Re: Regression on pg_restore to 16.0: DOMAIN not available to SQL function - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: Regression on pg_restore to 16.0: DOMAIN not available to SQL function
Date
Msg-id CAKFQuwaHjBv_u2t9YMftFiUPoLhphh8GepFGz1r_ttd82CkeQA@mail.gmail.com
Whole thread Raw
In response to Regression on pg_restore to 16.0: DOMAIN not available to SQL function  (Mark Hills <mark@xwax.org>)
List pgsql-hackers
On Friday, November 3, 2023, Mark Hills <mark@xwax.org> wrote:

  pg_restore: error: could not execute query: ERROR:  type "hash" does not exist
  LINE 7:         )::hash;
  [...]
  CONTEXT:  SQL function "gen_hash" during inlining

--
-- Relevant SQL declarations
--

Those were not all of the relevant SQL declarations.  In particular you haven’t shown where in your schema the gen_hash gets called.

Odds are you’ve violated a “cannot execute queries in …” rule in something like a generated column or a check expression.  That it didn’t fail before now is just a fluke.

I seem to recall another recent report of this for v16 that goes into more detail.

David J.

pgsql-hackers by date:

Previous
From: Ashutosh Bapat
Date:
Subject: Re: RFC: Logging plan of the running query
Next
From: Christoph Berg
Date:
Subject: Re: meson documentation build open issues