Re: System Table Query - Mailing list pgsql-general

From Stephan Szabo
Subject Re: System Table Query
Date
Msg-id 20020307213043.T94608-100000@megazone23.bigpanda.com
Whole thread Raw
In response to System Table Query  (John Bell <jbellpostgres@yahoo.com.au>)
Responses Re: System Table Query
List pgsql-general
On Fri, 8 Mar 2002, [iso-8859-1] John Bell wrote:

> Can anyone tell me where the ON DELETE <action> and ON
> UPDATE <action> rules for foreign keys are stored in
> the system tables.  I would have expected to find them
> in one of the relevent pg_trigger entries (ie. one
> with a tgtype of 9, 17 or 21).  However there is no
> difference in these entries regardless of the value of
> <action>.  I have also scoured other system tables to
> no avail.

It's based on the function called by the trigger (tgfoid).


pgsql-general by date:

Previous
From: Samik Raychauhduri
Date:
Subject: Re: NEWBIE: Date format/timestamp issue ?
Next
From: John Bell
Date:
Subject: Re: System Table Query