From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: Ross J. Reedstrom <reedstrm@rice.edu>
Cc: Patrick Welche <prlw1@newn.cam.ac.uk>
Cc: pgsql-sql@postgresql.org
Subject: Re: [HACKERS] RULES
Date: Wed, 21 Nov 2001 08:43:06 -0800 (PST)
Message-ID: <20011121083853.V66185-100000@megazone23.bigpanda.com> (raw)
In-Reply-To: <20011121095731.C22603@rice.edu>
On Wed, 21 Nov 2001, Ross J. Reedstrom wrote:
Want to pop in here.
> On Wed, Nov 21, 2001 at 12:58:37PM +0000, Patrick Welche wrote:
> >
> > create table a (
> > id integer primary key
> > );
> >
> > create table b (
> > a_id integer references a(id) match full
> > );
> >
> > select * from pg_trigger where tgname ~* '^RI_';
> >
> > Gives me 3 rows. They all contain the same tgargs. Is it therefore
> > sufficient to select distinct tgnargs,tgargs if I just want to be able to
> > recreate the "references... match full" part of the create table statement?
Not quite, you'll lose the referential action information if you don't
include info out of tgfoids on the pk table's triggers and you'll lose the
deferment info if you don't pay attention to tgdeferrable and
tginitdeferred. In your case you're not using those, but...
There have been messages in the past about how to get the reference
information. You should be able to find a function or something in
the archives :)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sszabo@megazone23.bigpanda.com, reedstrm@rice.edu, prlw1@newn.cam.ac.uk
Subject: Re: [HACKERS] RULES
In-Reply-To: <20011121083853.V66185-100000@megazone23.bigpanda.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox