Transition tables for column-specific UPDATE triggers

From: Guy Burgess <guy(at)burgess(dot)co(dot)nz>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Transition tables for column-specific UPDATE triggers
Date: 2019-10-09 02:59:33
Message-ID: a3f75b9c-80d5-58d5-aeb9-8ca70ee4387b@burgess.co.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

The manual says:
https://www.postgresql.org/docs/current/sql-createtrigger.html

A column list cannot be specified when requesting transition relations.

And (I think the same point):

The standard allows transition tables to be used with
column-specific |UPDATE| triggers, but then the set of rows that
should be visible in the transition tables depends on the trigger's
column list. This is not currently implemented by PostgreSQL.

Are there any plans to allow transition tables to be used with
column-specific UPDATE triggers?  Or, is there another way for a trigger
function to see the rows changed by a column-specific UPDATE trigger?

Thanks

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Křehula 2019-10-09 07:10:36 Re: Case Insensitive Comparison with Postgres 12
Previous Message Morris de Oryx 2019-10-09 02:55:53 Re: Case Insensitive Comparison with Postgres 12