restrict modification of column values in BR triggers - Mailing list pgsql-hackers

From Miroslav Šimulčík
Subject restrict modification of column values in BR triggers
Date
Msg-id CAHRNM68GyOuzwLkfkfnDAbWKnqbbBpNW7pARQRP60JvhC_f-eg@mail.gmail.com
Whole thread Raw
Responses Re: restrict modification of column values in BR triggers  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Hi,

is there any way to prevent role from modifing values of some columns of NEW row in before row triggers? I revoked insert privilege from these columns to ensure that only default value can be inserted, but it is still posible to modify values being inserted using before row triggers. I can't revoke trigger privilege on that table, because this role must be able to create triggers on this table.

Thank you.

Best regards
Miroslav Simulcik

pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: pgstat documentation tables
Next
From: Marti Raudsepp
Date:
Subject: [PATCH] Cleanup: use heap_open/heap_close consistently