pg_contraint: 'action code' ?
Started by fkater@googlemail.comalmost 19 years ago3 messagesgeneral
Hi,
where are the 'action code' (type char) of foreign keys defined for ON
DELETE resp. ON UPDATE for the actions NO ACTION, RESTRICT, CASCADE, SET
NULL, SET DEFAULT in pg_contraint?
In the manual (8.2) it is mentioned but not explained.
Thank You
Felix
Re: pg_contraint: 'action code' ?
Felix Kater <fkater@googlemail.com> writes:
where are the 'action code' (type char) of foreign keys defined for ON
DELETE resp. ON UPDATE for the actions NO ACTION, RESTRICT, CASCADE, SET
NULL, SET DEFAULT in pg_contraint?
Per the comment in pg_constraint.h:
/*
* Valid values for confupdtype and confdeltype are the FKCONSTR_ACTION_xxx
* constants defined in parsenodes.h. Valid values for confmatchtype are
* the FKCONSTR_MATCH_xxx constants defined in parsenodes.h.
*/
regards, tom lane