Re: Table Updatable By Trigger Only

From: Osahon Oduware <osahon(dot)gis(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Table Updatable By Trigger Only
Date: 2017-06-20 15:22:44
Message-ID: CAGpiUSjq8Xb4chr7c_3jnVqy-8Lfoybbyx18C5VGM5PiqAk25w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Tom,

Ok, thanks.

On Tue, Jun 20, 2017 at 3:21 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Osahon Oduware <osahon(dot)gis(at)gmail(dot)com> writes:
> > The pg_trigger_depth() function solved the issue. Thanks a lot, you made
> my
> > day.
>
> If you start finding that that gets in your way for other purposes, you
> might try making table A's trigger function be SECURITY DEFINER and
> owned by a role that has permissions to change table B.
>
> regards, tom lane
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Melvin Davidson 2017-06-20 16:04:32 Re: Schedule
Previous Message Steve Clark 2017-06-20 15:12:02 Re: Schedule