check_function_bodies not doing much

From: Marcelo Lacerda <marceloslacerda(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: check_function_bodies not doing much
Date: 2018-08-07 19:17:18
Message-ID: CAPmRTtMC=4ZTZ_-oobpyDUqewn7r2WHzza-UPnx8cdbKmuG-TA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 correct behavior?

Example:
http://paste.debian.net/1037080/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2018-08-07 19:25:30 Re: check_function_bodies not doing much
Previous Message David G. Johnston 2018-08-07 19:16:49 Re: Instead trigger on a view to update base tables ?