Re: PL/pgSQL : notion of deferred execution - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: PL/pgSQL : notion of deferred execution
Date
Msg-id 20051211160039.GC27484@wolff.to
Whole thread Raw
In response to PL/pgSQL : notion of deferred execution  (Frank van Vugt <ftm.van.vugt@foxi.nl>)
Responses Re: PL/pgSQL : notion of deferred execution
List pgsql-general
On Sun, Dec 11, 2005 at 16:31:59 +0100,
  Frank van Vugt <ftm.van.vugt@foxi.nl> wrote:
>
> Ratio: when deferred triggers on table A are used to calculate field values of
> table B (which then obviously need an update), one might want to prevent
> direct updates on these fields of table B

It might also work for you to do this with access rights. The triggers can
have different access rights than the user that caused the trigger to fire.

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Performance large tables.
Next
From: "Foster, Stephen"
Date:
Subject: Re: [SQL] Looking for information on PostgreSQL Stored Procedures