I'll take a look at it. Thanks for the recommendation.
On Tue, Aug 7, 2018 at 7:22 PM Pavel Stehule
wrote:
>
>
> 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
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*
>
>
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 yea
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 pl
"David G. Johnston" writes:
> On Tue, Aug 7, 2018 at 12:31 PM, Tom Lane wrote:
>> Yes. It's supposed to be a syntax check, not a check that the function
>> would work when executed. (Depending on the particular PL you're using,
>> which you didn't mention, it might be a pretty weak syntax check
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 p
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 i
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 actua
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 cor
