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

From Gevik Babakhani
Subject Re: system catalog constraints question
Date
Msg-id 001001c861cc$7da95090$0a01a8c0@gevmus
Whole thread Raw
In response to Re: system catalog constraints question  ("Heikki Linnakangas" <heikki@enterprisedb.com>)
List pgsql-hackers
Thank you :) 

> -----Original Message-----
> From: Heikki Linnakangas [mailto:heikki@enterprisedb.com] 
> Sent: Monday, January 28, 2008 5:35 PM
> To: Gevik Babakhani
> Cc: pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS] system catalog constraints question
> 
> 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: GSSAPI doesn't play nice with non-canonical host names
Next
From: Steve Atkins
Date:
Subject: Re: CLUSTER and synchronized scans and pg_dump et al