<div class="Section1" style="layout-grid:15.6pt"><p class="MsoNormal"><font face="Times New Roman" size="2"><span
lang="EN-US"style="font-size:10.5pt"><br /> I'm currently working on a master student research project “support
triggerson columns” that is supervised by a professor from my university (Ottawa U). I have contacted Neil Conway
whosename is with this item on the TODO list. It happened that he actually lives very close to me(Queen's U in
Kingston).He has agreed that I work on this.<br /> Please take a look of my design (Some of the ideas are from Neil)<br
/><br/> - change gram.y for CREATE TRIGGER to support the optional column list for this feature,<br /> - change
CreateTrigStmt,trigger, trigdesc node to add support for an optional List of columns; change the various Node support
functions(equalfuncs.c, copyfuncs.c, etc.)<br /> - change InsertTrigger, (Copy+Free+ equal)TriggerDesc, Relationbuild
functionto add support an optional List of columns.<br /> - change the pg_trigger system catalog to support the new
column.<br /> - change CreateTrigger() to perform some semantic analysis on the list of columns (ensure no column names
areduplicated, ensure each name references an extent and non-dropped column, and so forth)<br /> - when deciding which
triggersto invoke (executePlan() in execMain.c), add logic to compare the list of columns in the to-be-executed
commandwith the list of columns in any applicable columns,and only fire a trigger of the column lists that are
appropriatelycompatible<br /> -investigate the interaction between the column list and rules<br /><br
/></span></font><pclass="MsoNormal"><font face="Times New Roman" size="2"><span lang="EN-US" style="font-size:10.5pt">I
havespent the past four months on this and I have finished the YYpaser, Catalog, trigger creation and some other
supportfunctions, I am working on trigger execution right now. I expect the project will be completed by the end of
July.I would like to know your comments on my design and the procedure of getting my work accepted.<br /><br />
Thanks<br/> Mark Wu<br /><br /><br /></span></font><font face="Arial" size="1"><span lang="EN-US"
style="font-size:9.0pt;
font-family:Arial"></span></font></div>
