For security the variable should be persistent.
Why should they? If it is a session variable, being created when needed or used with the right type could be enough?
If you would to do statical analyse (what you usually would), then variable should be persistent.
I do not understand what static analysis you would need/want to do on session variables.
Currently the big issue of plpgsql_check is work with temporary tables.
Do you mean that temporary table are too slow/costly?
Local objects or dynamic sql is stop for static check.
Hmm. If something is dynamic, it is not static, but I do not understand your point.
-- Fabien. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers