Per-function configuration parameters loss

From: "Dmitry Samokhin" <sdld(at)mail(dot)ru>
To: pgadmin-support(at)postgresql(dot)org
Subject: Per-function configuration parameters loss
Date: 2009-10-02 12:12:36
Message-ID: ha4qna$i4e$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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.

Regards,
Dmitry.

P.S. For 8.3 backend or later pgAdmin might generate the SET option within
CREATE OR REPLACE FUNCTION command for the SQL pane.

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Raymond O'Donnell 2009-10-02 12:33:37 Re: Viewing TEXT objects
Previous Message mad rug 2009-10-02 11:55:29 Re: Viewing TEXT objects