stable for each row before insert trigger

From: Олег Самойлов <splarv(at)ya(dot)ru>
To: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: stable for each row before insert trigger
Date: 2019-10-17 23:31:12
Message-ID: 925B864A-0C60-4A2A-9072-88FB5501323F@ya.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all.

According to documentation the words "VOLATILE, STABLE, IMMUTABLE" is somehow useful with trigger functions, for instance mentioned that the AFTER INSERT trigger should be VOLATILE. The question is how this words affect a for each row before insert trigger? Can be some optimisation here?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2019-10-17 23:41:58 Re: stable for each row before insert trigger
Previous Message pabloa98 2019-10-17 22:23:35 Re: drop database