Re: system catalog constraints question

From: "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>
To: "Gevik Babakhani" <pgdev(at)xs4all(dot)nl>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: system catalog constraints question
Date: 2008-01-28 16:34:31
Message-ID: 479E0417.4010603@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Gevik Babakhani wrote:
> Is there a way to query the column constraints between the tables of system
> catalog.
> For example pg_attribute.atttypid---->pg_type.oid. This is described in the
> docs of course , but does the system use something like pg_constaint
> or the system catalog constraints are enforced only in the code?

There is pg_depend, which is kind of like constraints, but enforced in
code.

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2008-01-28 16:36:02 Re: CLUSTER and synchronized scans and pg_dump et al
Previous Message Tom Lane 2008-01-28 16:33:50 Re: CLUSTER and synchronized scans and pg_dump et al