Re: check_function_bodies not doing much

2018-08-07 Thread Pavel Stehule
2018-08-08 0:02 GMT+02:00 Marcelo Lacerda : > That's a whole different nightmare that I'm expecting. > > > "Yep I double-checked all my functions to see if any would break if I > change this field mytable.a into 2 fields mytable.a1 and mytable.a2 and > everything is ok." > > *1 month later* >

Re: check_function_bodies not doing much

2018-08-07 Thread Marcelo Lacerda
That's a whole different nightmare that I'm expecting. "Yep I double-checked all my functions to see if any would break if I change this field mytable.a into 2 fields mytable.a1 and mytable.a2 and everything is ok." *1 month later* "Why is this error log for this application that I wrote one

Re: check_function_bodies not doing much

2018-08-07 Thread Merlin Moncure
On Tue, Aug 7, 2018 at 2:31 PM Tom Lane wrote: > > Marcelo Lacerda writes: > > I was trying to get postgres to warn me that I'm referencing a table that > > it doesn't exists inside a function so I was told on the IRC to check the > > setting "check_function_bodies", however when I use it in a

Re: check_function_bodies not doing much

2018-08-07 Thread David G. Johnston
On Tue, Aug 7, 2018 at 12:31 PM, Tom Lane wrote: > Marcelo Lacerda writes: > > I was trying to get postgres to warn me that I'm referencing a table that > > it doesn't exists inside a function so I was told on the IRC to check the > > setting "check_function_bodies", however when I use it in a

Re: check_function_bodies not doing much

2018-08-07 Thread Tom Lane
Marcelo Lacerda writes: > I was trying to get postgres to warn me that I'm referencing a table that > it doesn't exists inside a function so I was told on the IRC to check the > setting "check_function_bodies", however when I use it in a plpgsql > function it doesn't actually check if the tables

Re: check_function_bodies not doing much

2018-08-07 Thread Pavel Stehule
Hi 2018-08-07 21:17 GMT+02:00 Marcelo Lacerda : > I was trying to get postgres to warn me that I'm referencing a table that > it doesn't exists inside a function so I was told on the IRC to check the > setting "check_function_bodies", however when I use it in a plpgsql > function it doesn't

check_function_bodies not doing much

2018-08-07 Thread Marcelo Lacerda
I was trying to get postgres to warn me that I'm referencing a table that it doesn't exists inside a function so I was told on the IRC to check the setting "check_function_bodies", however when I use it in a plpgsql function it doesn't actually check if the tables in the body exist. Is this the