On 07/26/2018 06:57 AM, Leland Weathers wrote:
Before you mentioned a trigger. I am not seeing that in the schema you sent. Is there one and if so what is it's definition and that of its associated function?I was referring to the "built-in" PostgreSQL system trigger for validating fk constraints are met. The trigger that uses the "SELECT 1 FROM ONLY..." query. That particular query which the logs say I don't have permissions to execute is not part of my schema/code.What does show?: select session_user, current_user;For this particular example, the session_user is: lw, current_user is dba (database and schema owner role)
So if I am following neither of these roles have permissions on the tables. Is that correct?
If you try the INSERT as system_admin, jb or gb does it work?
INSERT INTO results.historyitem (batchid,datasourceid,sequence_order) VALUES (6,20,1);-- Adrian Klaver[email protected] <mailto:[email protected]>
-- Adrian Klaver [email protected]
