Search Postgresql Archives

Re: Detecting which columns a query will modify in a function called by a trigger

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 3/3/20 3:06 PM, David G. Johnston wrote:
On Tue, Mar 3, 2020 at 3:48 PM Adrian Klaver <adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>> wrote:

    The link was for automatically updateable views. If you want to do
    something more involved then see:

    https://www.postgresql.org/docs/12/rules-views.html#RULES-VIEWS-UPDATE


CREATE TRIGGER works with views; I usually see recommendations to start there and avoid rules if at all possible.

The above suggests triggers then rules.


David J.


--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux