Request a Demo
Home   >   mailing lists

Re: let ALTER COLUMN SET DATA TYPE cope with trigger dependency - Mailing list pgsql-hackers

From jian he
Subject Re: let ALTER COLUMN SET DATA TYPE cope with trigger dependency
Date
Msg-id CACJufxH-Ngr9e7_bT+7d-bFMACqd-efAV3YSgPJyfMp4T9P5AQ@mail.gmail.com
Whole thread Raw
In response to Re: let ALTER COLUMN SET DATA TYPE cope with trigger dependency  (jian he <jian.universality@gmail.com>)
List pgsql-hackers
Tree view 
hi.

V3 is attached. this should be more neat.
Now it looks very similar to how statistics cope with column data type change.

For statistics, in ATPostAlterTypeParse we will call
transformStatsStmt, we need to do the similar thing for the trigger
WHEN clause.
I introduced transformTriggerStmt and placed it in
src/backend/commands/trigger.c, which should be fine, I think.
It will be invoked from within CreateTriggerFiringOn.



--
jian
https://www.enterprisedb.com/
Attachment

pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: Flush some statistics within running transactions
Next
From: Chao Li
Date:
Subject: Re: Assert the timestamp is available for ORIGN_DIFFERS conflicts