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 coerci

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 coerc

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, not