From: | Wei Shi <weishisky(at)yahoo(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | information schema |
Date: | 2004-05-30 04:52:36 |
Message-ID: | 20040530045236.68024.qmail@web60306.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Does anybody know why "key_column_usage", and
"referential_constraints" are empty in
information_schema? Have these been implemented?
e.g.
cms=# select * from
information_schema.key_column_usage;
constraint_catalog | constraint_schema |
constraint_name | table_catalog | table_schema |
table_name | column_name | ordinal_position
--------------------+-------------------+-----------------+---------------+--------------+------------+-------------+------------------
(0 rows)
cms=# select * from
information_schema.referential_constraints;
constraint_catalog | constraint_schema |
constraint_name | unique_constraint_catalog |
unique_constraint_schema | unique_constraint_name |
match_option | update_rule | delete_rule
--------------------+-------------------+-----------------+---------------------------+--------------------------+------------------------+--------------+-------------+-------------
(0 rows)
Thanks.
Wei
__________________________________
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Jurgen Defurne | 2004-05-30 08:59:05 | Trying to mail from my virtual network |
Previous Message | Tom Lane | 2004-05-30 03:58:27 | Re: ERROR: invalid page header in block 67 of relation "pg_proc" |