Transition tables for column-specific UPDATE triggers - Mailing list pgsql-general

From Guy Burgess
Subject Transition tables for column-specific UPDATE triggers
Date
Msg-id a3f75b9c-80d5-58d5-aeb9-8ca70ee4387b@burgess.co.nz
Whole thread Raw
Responses Re: Transition tables for column-specific UPDATE triggers
List 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

pgsql-general by date:

Previous
From: Morris de Oryx
Date:
Subject: Re: Case Insensitive Comparison with Postgres 12
Next
From: Pavel Křehula
Date:
Subject: Re: Case Insensitive Comparison with Postgres 12