System Table Query

From: John Bell <jbellpostgres(at)yahoo(dot)com(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: System Table Query
Date: 2002-03-08 02:55:41
Message-ID: 20020308025541.1200.qmail@web21010.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Bowlby 2002-03-08 03:22:40 \d+ breakage in 7.2
Previous Message Lamar Owen 2002-03-08 02:26:07 Re: Installing 7.2 on RedHat 7.1