Re: Regression on pg_restore to 16.0: DOMAIN not available to SQL function

On Friday, November 3, 2023, Mark Hills <mark(at)xwax(dot)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.