Re: pg_contraint: 'action code' ? - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_contraint: 'action code' ?
Date
Msg-id 462.1178633004@sss.pgh.pa.us
Whole thread Raw
In response to pg_contraint: 'action code' ?  (Felix Kater <fkater@googlemail.com>)
Responses Re: pg_contraint: 'action code' ?
List pgsql-general
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

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: are foreign keys realized as indexes?
Next
From: Tom Lane
Date:
Subject: Re: are foreign keys realized as indexes?