Re: psql should show disabled internal triggers - Mailing list pgsql-hackers

From Bernd Helmle
Subject Re: psql should show disabled internal triggers
Date
Msg-id 2459C95FC1B4271C8DE2B13D@apophis.credativ.lan
Whole thread Raw
In response to psql should show disabled internal triggers  (Andres Freund <andres@2ndquadrant.com>)
Responses Re: psql should show disabled internal triggers
List pgsql-hackers

--On 18. September 2013 13:52:29 +0200 Andres Freund 
<andres@2ndquadrant.com> wrote:

> If you do ALTER TABLE ... DISABLE TRIGGER ALL; and then individually
> re-enable the disabled triggers it's easy to miss internal triggers.
> A \d+ tablename will not show anything out of the ordinary for that
> situation since we don't show internal triggers. But foreign key checks
> won't work.
> So, how about displaying disabled internal triggers in psql?

Hi had exactly the same concerns this morning while starting to look at the 
ENABLE/DISABLE constraint patch. However, i wouldn't display them as 
triggers, but maybe more generally as "disabled constraints" or such.

-- 
Thanks
Bernd



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Docs fix in advanced.sgml
Next
From: Robert Haas
Date:
Subject: Re: UTF8 national character data type support WIP patch and list of open issues.