<div class="Section1" style="layout-grid:15.6pt"><p class="MsoNormal"
style="margin-bottom:12.0pt;layout-grid-mode:char"><fontface="Times New Roman" size="2"><span lang="EN-US"
style="font-size:10.5pt">I'mcurrently working on a master student research project “support triggers on columns” that
issupervised by a professor from my university (Ottawa U). I have contacted Neil Conway whose name is with this item
onthe TODO list. It happened that he actually lives very close to me(Queen's U in Kingston). He has agreed that I work
onthis.<br /> Please take a look of my design (Some of the ideas are from Neil)<br /><br /> - change gram.y for CREATE
TRIGGERto support the optional column list for this feature,<br /> - change CreateTrigStmt, trigger, trigdesc node to
addsupport 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 function to add support an optional
Listof columns.<br /> - change the pg_trigger system catalog to support the new column .<br /> - change CreateTrigger()
toperform some semantic analysis on the list of columns (ensure no column names are duplicated, ensure each name
referencesan extent and non-dropped column, and so forth)<br /> - when deciding which triggers to invoke (executePlan()
inexecMain.c), add logic to compare the list of columns in the to-be-executed command with the list of columns in any
applicablecolumns,and only fire a trigger of the column lists that are appropriately compatible<br /> -investigate the
interactionbetween the column list and rules</span></font><p class="MsoNormal" style="layout-grid-mode:char"><font
face="TimesNew Roman" size="2"><span lang="EN-US" style="font-size:10.5pt">I have spent the past four months on this
andI have finished the YYpaser, Catalog, trigger creation and some other support functions, I am working on trigger
executionright now. I expect the project will be completed by the end of July. I would like to know your comments on my
designand the procedure of getting my work accepted.<br /><br /> Thanks<br /> Mark Wu</span></font><p
class="MsoNormal"><fontface="Arial" size="1"><span lang="EN-US" style="font-size:
9.0pt;font-family:Arial"> </span></font></div>
