system catalog constraints question
Hi,
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?
Regards,
Gevik.
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
Thank you :)
Show quoted text
-----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 questionGevik 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 isdescribed
in the docs of course , but does the system use something like
pg_constaint or the system catalog constraints are enforcedonly in the code?
There is pg_depend, which is kind of like constraints, but
enforced in code.--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com