setuid for defaults, constraints and triggers (Was: What user to [sic] defaults execute as?) - Mailing list pgsql-hackers

From Bruno Wolff III
Subject setuid for defaults, constraints and triggers (Was: What user to [sic] defaults execute as?)
Date
Msg-id 20021031145402.GA12641@wolff.to
Whole thread Raw
In response to Re: [GENERAL] What user to defaults execute as?  (Bruno Wolff III <bruno@wolff.to>)
Responses Re: setuid for defaults, constraints and triggers (Was:
List pgsql-hackers
Constraints also run as the user modifying a table instead of the table
owner.
Again I don't see a good reason to want to execute constraints as the
user modifying a table. But I do think there can be reasons to want to
execute them as the table owner.

To summarize, my suggestion for change is:

Execute default expressions and constraints as the owner of the table.
Execute triggers as the owner of the trigger.


pgsql-hackers by date:

Previous
From: "Zeugswetter Andreas SB SD"
Date:
Subject: Re: float output precision questions
Next
From: "Pedro M. Ferreira"
Date:
Subject: Re: float output precision questions