What is OLD in INSTEAD OF trigger?

From: Jinhua Luo <luajit(dot)io(at)gmail(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: What is OLD in INSTEAD OF trigger?
Date: 2018-09-18 11:05:23
Message-ID: CAAc9rOxR-VQR-Bgy2TRf0ajYyAB3X5pygujc76mmbSBftPV84A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

If the view definition is too complex to be automatic updateable, then
how postgresql defines OLD in INSTEAD OF trigger? It cannot bind any
column on any table directly then, right?

Unless postgresql refresh view as table source before executing
trigger? Then it may filter (WHERE sub-clause of UPDATE/DELETE) the
rows to be update, and use those rows as OLD?

Browse pgsql-hackers by date

  From Date Subject
Next Message Prabhat Sahu 2018-09-18 11:07:48 Re: [HACKERS] Bug in to_timestamp().
Previous Message Jinhua Luo 2018-09-18 10:55:38 Is it possible for postgres_fdw to push down queries on co-located tables?