Re: system catalog constraints question - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: system catalog constraints question
Date
Msg-id 479E0417.4010603@enterprisedb.com
Whole thread Raw
In response to system catalog constraints question  ("Gevik Babakhani" <pgdev@xs4all.nl>)
Responses Re: system catalog constraints question
List 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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: CLUSTER and synchronized scans and pg_dump et al
Next
From: Tom Lane
Date:
Subject: Re: CLUSTER and synchronized scans and pg_dump et al