Mark Hills writes:
> On Fri, 3 Nov 2023, Tom Lane wrote:
>> Right, so the 910eb61b2 fix explains it. I guess I'd better
>> expand the release note entry, because we'd not foreseen this
>> particular failure mode.
> Indeed, and curiosity got the better of me so I constructed a minimal test
> cas
On Fri, 3 Nov 2023, Tom Lane wrote:
> Mark Hills writes:
> > On Fri, 3 Nov 2023, Tom Lane wrote:
> >> However, then it's not clear why it would've worked
> >> in 15.4 which does the same thing. I wonder whether you are
> >> using this function in a column default for the troublesome
> >> table.
Mark Hills writes:
> On Fri, 3 Nov 2023, Tom Lane wrote:
>> However, then it's not clear why it would've worked
>> in 15.4 which does the same thing. I wonder whether you are
>> using this function in a column default for the troublesome
>> table.
> Yes, it's just a simple DEFAULT:
> CREATE T
On Fri, 3 Nov 2023, Tom Lane wrote:
> Mark Hills writes:
> > I'm having errors restoring with pg_restore to v16.0, it appears to be a
> > regression or bug. The same file restored to v15.4 without problem.
>
> > During the restore:
>
> > pg_restore: error: could not execute query: ERROR: ty
Mark Hills writes:
> I'm having errors restoring with pg_restore to v16.0, it appears to be a
> regression or bug. The same file restored to v15.4 without problem.
> During the restore:
> pg_restore: error: could not execute query: ERROR: type "hash" does not
> exist
> LINE 7: )::
On Friday, November 3, 2023, Mark Hills 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 th
On 2023-11-03 Fr 06:17, Mark Hills wrote:
I'm having errors restoring with pg_restore to v16.0, it appears to be a
regression or bug. The same file restored to v15.4 without problem.
During the restore:
pg_restore: error: could not execute query: ERROR: type "hash" does not
exist
LINE
