Re: View definition changes after reloading pg_dump export

2022-09-01 Thread Ron
On 9/1/22 09: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 implicit

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 implicit

Re: View definition changes after reloading pg_dump export

2022-09-01 Thread Tom Lane
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 implicit coercion steps into your initial,

View definition changes after reloading pg_dump export

2022-09-01 Thread Wesley Schwengle
Hello all, For our application we are generating a template.sql file with our schema in it by using pg_dump to a template.sql file. When we apply a DB change we load this template into a new database, apply the changes and export it again. This works, but we run into a small issue recently