From e4718f2c9eff30dedd022fac53a1f874aa1955d8 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Sun, 9 Nov 2008 21:24:33 +0000 Subject: Replace pg_class.reltriggers with relhastriggers, which is just a boolean hint ("there might be triggers") rather than an exact count. This is necessary catalog infrastructure for the upcoming patch to reduce the strength of locking needed for trigger addition/removal. Split out and committed separately for ease of reviewing/testing. In passing, also get rid of the unused pg_class columns relukeys, relfkeys, and relrefs, which haven't been maintained in many years and now have no chance of ever being maintained (because of wishing to avoid locking). Simon Riggs --- doc/src/sgml/catalogs.sgml | 58 ++++++++++++---------------------------------- 1 file changed, 15 insertions(+), 43 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml index faee42ba103..ae9a6cfd8ec 100644 --- a/doc/src/sgml/catalogs.sgml +++ b/doc/src/sgml/catalogs.sgml @@ -1,4 +1,4 @@ - + @@ -1711,37 +1711,6 @@ - - reltriggers - int2 - - - Number of triggers on the table; see - pg_trigger catalog - - - - - relukeys - int2 - - Unused (not the number of unique keys) - - - - relfkeys - int2 - - Unused (not the number of foreign keys on the table) - - - - relrefs - int2 - - Unused - - relhasoids bool @@ -1765,11 +1734,21 @@ bool - True if table has rules; see + True if table has (or once had) rules; see pg_rewrite catalog + + relhastriggers + bool + + + True if table has (or once had) triggers; see + pg_trigger catalog + + + relhassubclass bool @@ -4499,13 +4478,6 @@ - - - pg_class.reltriggers needs to agree with the - number of triggers found in this table for each relation. - - - @@ -6818,13 +6790,13 @@ hasrules boolean pg_class.relhasrules - true if table has rules + true if table has (or once had) rules hastriggers boolean - pg_class.reltriggers - true if table has triggers + pg_class.relhastriggers + true if table has (or once had) triggers -- cgit v1.2.3