On 10/19/2004 7:32 AM, Andrew Sullivan wrote:
> On Mon, Oct 18, 2004 at 07:15:01PM -0400, Jan Wieck wrote:
>> No, we definitely need to utilize tg_enabled for triggers.
> 
> I've had situations where flipping that bit didn't seem to work,
> however.
> 
> A
> 

Flipping that bit alone doesn't cause a system cache invalidation of the 
corresponding pg_class entry, which in turn would cause the relation 
cache of all backends to rebuild the in-memory information about the 
table. That only happens if you update the pg_class row in the same 
transaction. A dummy update like "set relname=relname" is enough.


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck at Yahoo.com #