Re: about the RULE system - Mailing list pgsql-general

From Tom Lane
Subject Re: about the RULE system
Date
Msg-id 10425.1166036486@sss.pgh.pa.us
Whole thread Raw
In response to about the RULE system  (Rafal Pietrak <rafal@zorro.isa-geek.com>)
Responses Re: about the RULE system  (Rafal Pietrak <rafal@zorro.isa-geek.com>)
List pgsql-general
Rafal Pietrak <rafal@zorro.isa-geek.com> writes:
> I thought trigger functions execute at root/postgres security level?

No.  You probably want to make that function SECURITY DEFINER so it
executes as the owner, but this isn't default for triggers.

            regards, tom lane

pgsql-general by date:

Previous
From: Tony Caduto
Date:
Subject: Re: MySQL drops support for most distributions
Next
From: Markus Schiltknecht
Date:
Subject: Re: Large Object to Bytea Conversion