System Table Query - Mailing list pgsql-general

From John Bell
Subject System Table Query
Date
Msg-id 20020308025541.1200.qmail@web21010.mail.yahoo.com
Whole thread Raw
Responses Re: System Table Query  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-general
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.

John Bell


http://movies.yahoo.com.au - Yahoo! Movies
- Vote for your nominees in our online Oscars pool.

pgsql-general by date:

Previous
From: Lamar Owen
Date:
Subject: Re: Installing 7.2 on RedHat 7.1
Next
From: Chris Bowlby
Date:
Subject: \d+ breakage in 7.2