information_schema.referential_constraints contains NULLs

From: CG <cgg007(at)yahoo(dot)com>
To: postgresql listserv <pgsql-general(at)postgresql(dot)org>
Subject: information_schema.referential_constraints contains NULLs
Date: 2011-10-14 15:11:12
Message-ID: 1318605072.74535.YahooMailNeo@web37907.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

PostgreSQL 9.1.0

For some of the referential constraints listed in my information_schema.referential_constraints table the values for the fields unique_constraint_catalog, unique_constraint_schema, and unique_constraint_name are NULL. There doesn't seem to be any rhyme or reason to which ones have values and which ones don't. They should all have values, right? Any ideas what could be going on?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2011-10-14 15:37:31 Re: information_schema.referential_constraints contains NULLs
Previous Message Phil Couling 2011-10-14 14:22:41 Re: Error: timestamp with timezone + interval is not immutable while creating index