Felix Kater <fkater@xxxxxxxxxxxxxx> 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