Re: about the RULE system

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rafal Pietrak <rafal(at)zorro(dot)isa-geek(dot)com>
Cc: pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: Re: about the RULE system
Date: 2006-12-13 19:01:26
Message-ID: 10425.1166036486@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Rafal Pietrak <rafal(at)zorro(dot)isa-geek(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Markus Schiltknecht 2006-12-13 19:03:53 Re: Large Object to Bytea Conversion
Previous Message Tony Caduto 2006-12-13 19:00:16 Re: MySQL drops support for most distributions