2009/10/2 Dmitry Samokhin <s...@mail.ru>: > When any server configuration parameters (or variables) are set on a > per-function basis, the script displayed in the pgAdmin SQL pane looks like > this: > > CREATE OR REPLACE FUNCTION ... ; > ALTER FUNCTION ... SET ...; > > If then I edit the function body and save my work, all variables are lost, > since (it can be cheked easily) pgAdmin does not generate neither SET option > in the CREATE OR REPLACE FUNCTION command nor separate ALTER FUNCTION ... > SET ... one. > > This is critical since for security reasons functions with the SECURITY > DEFINER option should contain appropriate 'search_path' variable setting. > And now a DB developer/admin has to double-check per-function variables when > editing functions using pgAdmin.
Thanks - fixed in SVN for 1.10.1 -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
