View definition changes after reloading pg_dump export

2022-09-01 Thread Wesley Schwengle
tore(ARRAY['bar'::text, 'baz'::text], ARRAY[foo.bar, foo.baz::character varying]::text[])) AS sometext FROM foo ); \d+ foo_view_copy -- yields as View definition -- SELECT myfunc(hstore(ARRAY['bar'::text, 'baz'::text], ARRAY[foo.bar::text, foo.baz::character varying::text])) AS sometext -- FROM foo; ``` -- Wesley Schwengle, Developer xxllnc Zaaksysteem, https://www.zaaksysteem.nl

Re: View definition changes after reloading pg_dump export

2022-09-01 Thread Wesley Schwengle
On 9/1/22 10:08, Tom Lane wrote: Wesley Schwengle 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 imp