Re: [GENERAL] Table Updatable By Trigger Only

2017-06-20 Thread Osahon Oduware
Hi Tom, Ok, thanks. On Tue, Jun 20, 2017 at 3:21 PM, Tom Lane wrote: > Osahon Oduware 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

Re: [GENERAL] Table Updatable By Trigger Only

2017-06-20 Thread Tom Lane
Osahon Oduware 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

Re: [GENERAL] Table Updatable By Trigger Only

2017-06-20 Thread Osahon Oduware
Hi Achilleas, The pg_trigger_depth() function solved the issue. Thanks a lot, you made my day. On Tue, Jun 20, 2017 at 12:58 PM, Achilleas Mantzios < ach...@matrix.gatewaynet.com> wrote: > On 20/06/2017 14:43, Osahon Oduware wrote: > > Hi All, > > I have a trigger on a PostGIS table (say table

Re: [GENERAL] Table Updatable By Trigger Only

2017-06-20 Thread Achilleas Mantzios
On 20/06/2017 14:43, Osahon Oduware wrote: Hi All, I have a trigger on a PostGIS table (say table A) that automatically updates another PostGIS table (say table B). Also, users connect to these tables (table A and B) using QGIS. However, I want the updates to table B to be done by the trigger