Re: PL/pgSQL : notion of deferred execution

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Frank van Vugt <ftm(dot)van(dot)vugt(at)foxi(dot)nl>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: PL/pgSQL : notion of deferred execution
Date: 2005-12-11 16:00:39
Message-ID: 20051211160039.GC27484@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, Dec 11, 2005 at 16:31:59 +0100,
Frank van Vugt <ftm(dot)van(dot)vugt(at)foxi(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Foster, Stephen 2005-12-11 16:35:51 Re: [SQL] Looking for information on PostgreSQL Stored Procedures
Previous Message Bruno Wolff III 2005-12-11 15:41:27 Re: Performance large tables.