Re: PL/pgSQL : notion of deferred execution

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: PL/pgSQL : notion of deferred execution
Дата
Msg-id 20051211160039.GC27484@wolff.to
обсуждение исходный текст
Ответ на PL/pgSQL : notion of deferred execution  (Frank van Vugt <ftm.van.vugt@foxi.nl>)
Ответы Re: PL/pgSQL : notion of deferred execution  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: Performance large tables.
Следующее
От: "Foster, Stephen"
Дата:
Сообщение: Re: [SQL] Looking for information on PostgreSQL Stored Procedures