Re: View definition changes after reloading pg_dump export

On 9/1/22 10:08, Tom Lane wrote:
> Wesley Schwengle <wesley(dot)schwengle(at)xxllnc(dot)nl> writes:
>> There is a view that we create and it uses a function and the view
>> definition changes between runs. I'm not sure why this is happening,
>> does someone know?
>
> The core reason for the discrepancy is that the parser inserts
> implicit coercion steps into your initial, not-very-consistently-typed
> query; but the view-dumping logic (ruleutils.c) tends to display
> those steps as explicit coercions.

Thanks for the clarification, it makes a whole lot of sense. And indeed,
when I type the SQL like so ARRAY[foo.bar::text, foo.baz::varchar::text]
the view definition does not change between runs.

Cheers,
Wesley

--
Wesley Schwengle, Developer
xxllnc Zaaksysteem, https://www.zaaksysteem.nl