Postgres Pro
Downloads
Home   >   mailing lists

information_schema.referential_constraints contains NULLs - Mailing list pgsql-general

From CG
Subject information_schema.referential_constraints contains NULLs
Date
Msg-id 1318605072.74535.YahooMailNeo@web37907.mail.mud.yahoo.com
Whole thread Raw
Responses Re: information_schema.referential_constraints contains NULLs  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
PostgreSQL 9.1.0


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

pgsql-general by date:

Previous
From: Phil Couling
Date:
Subject: Re: Error: timestamp with timezone + interval is not immutable while creating index
Next
From: Tom Lane
Date:
Subject: Re: information_schema.referential_constraints contains NULLs