Re: DML Restriction unless through a function

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Adam Witney <awitney(at)sghms(dot)ac(dot)uk>
Cc: val(at)webtribe(dot)net, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: DML Restriction unless through a function
Date: 2004-06-30 14:35:41
Message-ID: 20040630143541.GA14493@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Jun 30, 2004 at 15:02:33 +0100,
Adam Witney <awitney(at)sghms(dot)ac(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andy B 2004-06-30 14:44:18 Enough RAM for entire Database.. cost aside, is this going to be fastest?
Previous Message Tom Lane 2004-06-30 14:32:56 Re: minimum operators for b-tree, r-tree