Trigger Function DML and Permissions - Mailing list pgsql-general

From Raymond
Subject Trigger Function DML and Permissions
Date
Msg-id 200307201905.06885.support@bigriverinfotech.com
Whole thread Raw
Responses Re: Trigger Function DML and Permissions  (Jason Godden <jasongodden@optushome.com.au>)
List pgsql-general
Appears Postgres 7.3.3 utilizes current user permissions when executing DML
within trigger functions.

How would one transparently (from the client perspective) switch users for the
purpose of trigger function execution and the restore to the original after
execution?

This issue will arise again with Insert, Update and Delete functions.

Raymond

pgsql-general by date:

Previous
From: boris@ebuero.de
Date:
Subject: readline, library, not found and so on
Next
From: Bruce Momjian
Date:
Subject: Re: Datatypes and performance