Question: A way to EXTEND the SQL Validation of EXECUTE 'UDPATE ...'; to specific functions: util.sql_exec('UPDATE ...' );

okbob / plpgsql_check

plpgsql_check is a linter tool (does source code static analyze) for the PostgreSQL language plpgsql (the native language for PostgreSQL store procedures).

https://groups.google.com/forum/#!forum/postgresql-extensions-hacking

Other

641 stars 53 forks source link

Question: A way to EXTEND the SQL Validation of EXECUTE 'UDPATE ...'; to specific functions: util.sql_exec('UPDATE ...' ); #163

Closed kirkw closed 11 months ago

kirkw commented 11 months ago

We have a wrapper function for EXECUTE, and did not realize that plpgsql_check() does such a great job of scanning EXECUTE. Would there be any way to somehow flag some internal function to get that same treatment?

I am guessing "no"... But thought it was worth the ask...

Thanks!

okbob commented 11 months ago

No, there is nothing for this purpose, and I have not any idea how to design it well.