Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 25A11475B85
	for <pgsql-sql@postgresql.org>; Wed, 27 Nov 2002 05:13:40 -0500 (EST)
Received: from post.webmailer.de (natsmtp01.webmailer.de [192.67.198.81])
	by postgresql.org (Postfix) with ESMTP id DCDA0475AE5
	for <pgsql-sql@postgresql.org>; Wed, 27 Nov 2002 05:13:38 -0500 (EST)
Received: from dell (p50915073.dip.t-dialin.net [80.145.80.115])
	by post.webmailer.de (8.9.3/8.8.7) with ESMTP id LAA19080;
	Wed, 27 Nov 2002 11:13:16 +0100 (MET)
Content-Type: text/plain;
  charset="iso-8859-15"
From: Tilo Schwarz <mail@tilo-schwarz.de>
To: Tom Lane <tgl@sss.pgh.pa.us>
Subject: Re: Question on SQL and pg_-tables
Date: Wed, 27 Nov 2002 11:13:40 +0100
User-Agent: KMail/1.4.3
References: <200211251721.27543.mail@tilo-schwarz.de>
	<8774.1038249125@sss.pgh.pa.us>
In-Reply-To: <8774.1038249125@sss.pgh.pa.us>
Cc: pgsql-sql@postgresql.org
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Message-Id: <200211271113.40827.mail@tilo-schwarz.de>
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200211/415
X-Sequence-Number: 10557

> Tilo Schwarz <mail@tilo-schwarz.de> writes:
> > - Is it possible to get not only the two tables, but also their
> > corresponding two columns involved in a RI-Constraint out of the pg_*
> > tables just with a SQL query?
>
> Not easily --- the column info is buried in the pg_trigger.tgargs entries
> for the RI triggers, which there is no good way to take apart in plain SQ=
L.
>
> You might care to start experimenting with 7.3 instead; the new
> pg_constraint table makes this much easier.

Thank you, I'll check that out.

Regards,

	Tilo