Postgres Pro
Downloads
Home   >   mailing lists

Thread: pg_contraint: 'action code' ?

pg_contraint: 'action code' ?

From
Felix Kater
Date:
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' ?

From
Tom Lane
Date:
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

Re: pg_contraint: 'action code' ?

From
Felix Kater
Date:
On Tue, 08 May 2007 10:03:24 -0400
Tom Lane <tgl@sss.pgh.pa.us> wrote:

>  * the FKCONSTR_MATCH_xxx constants defined in parsenodes.h.

True! ;-)
Thank you so much.

Felix