Re: DML Restriction unless through a function - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: DML Restriction unless through a function
Date
Msg-id 20040630143541.GA14493@wolff.to
Whole thread Raw
In response to Re: DML Restriction unless through a function  (Adam Witney <awitney@sghms.ac.uk>)
Responses Re: DML Restriction unless through a function  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Wed, Jun 30, 2004 at 15:02:33 +0100,
  Adam Witney <awitney@sghms.ac.uk> wrote:
>
> Out of interest, what are the issues?

You should be able to find a more accurate description in the archives, but
my memory is that when you run a security definer function in a view
(this shouldn't apply if it is used as a default for a column in the view) it
runs with the authority of the view creator ran than the function creator.
In practice that probably isn't a problem, since normally they would be
the same person.

pgsql-general by date:

Previous
From: Adam Witney
Date:
Subject: Re: DML Restriction unless through a function
Next
From: joseph speigle
Date:
Subject: Re: mysql2postgres has no documentation?