Change the default [tgenabled] for new "internal" triggers ?

From: <david(dot)sahagian(at)emc(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Change the default [tgenabled] for new "internal" triggers ?
Date: 2012-03-23 19:29:34
Message-ID: F3CBFBA88397EA498B22A05FFA9EC49D697BB34F@MX22A.corp.emc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Today I learned that . . .
the firing of even "internally generated constraint triggers" is affected by the value of [session_replication_role].

Sadly, I had previously assumed that such "internal" triggers did not care about [s_r_r].

Also learned that . . .
when a FK constraint gets made, its pg_trigger.tgenabled = ' O'.

QUESTION:
Is the a way to configure Postgres such that tgenabled = ' A' automatically when the FK constraint gets made ?

Or must I !un-automatedly! do a . . .
alter table MYTABLE ENABLE ALWAYS TRIGGER "RI_ConstraintTrigger_18656"
whenever
somebody makes a FK ?!?

Thanks,
-dvs-

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2012-03-23 19:35:16 Re: PostgreSQL 64 Bit XIDs - Transaction IDs
Previous Message Gerhard Wiesinger 2012-03-23 19:15:16 Re: PostgreSQL 64 Bit XIDs - Transaction IDs