Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Clarification to catalog-pg-class


  • From: Josh Berkus <josh(at)agliodbs(dot)com>
  • To: pgsql-docs(at)postgresql(dot)org
  • Subject: Clarification to catalog-pg-class
  • Date: Wed, 28 Jan 2009 11:18:27 -0800
  • Message-id: <4980AF83.50707@agliodbs.com> <text/plain>

All,

Currently, catalog-pg-class is a bit confusing as to where FKs are tracked in pg_class. Please update the lines for relchecks and reltriggers to read:

relchecks int2 Number of check constraints on the table (but not other types of constraints); see pg_constraint catalog reltriggers int2 Number of triggers on the table, including constraint-triggers for foreign keys; see pg_trigger catalog

--Josh Berkus



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group