Re: pg_contraint: 'action code' ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Felix Kater <fkater(at)googlemail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_contraint: 'action code' ?
Date: 2007-05-08 14:03:24
Message-ID: 462.1178633004@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Felix Kater <fkater(at)googlemail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-05-08 14:06:44 Re: are foreign keys realized as indexes?
Previous Message Martijn van Oosterhout 2007-05-08 13:54:08 Re: are foreign keys realized as indexes?