working on support triggers on columns
От | Mark Wu |
---|---|
Тема | working on support triggers on columns |
Дата | |
Msg-id | 20040701233542.MUPG10254.fep04-mail.bloor.is.net.cable.rogers.com@grace обсуждение исходный текст |
Ответы |
Re: working on support triggers on columns
Re: working on support triggers on columns |
Список | pgsql-hackers |
<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>
В списке pgsql-hackers по дате отправления: