From: Andrzej Mazurkiewicz <andrzej@mazurkiewicz.org>
To: fabriziomello@gmail.com
Cc: "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Subject: Re: Inheritance of foregn key constraints - dropping isinternal
 triggers by a
Date: Wed, 02 Apr 2014 16:45:30 +0200
Message-ID: <2729604.PO7CB1FP43@tata>
User-Agent: KMail/4.12.2 (Linux/3.13.0-10-generic; KDE/4.12.2; x86_64; ; )
In-Reply-To: 
 <CAFcNs+qQvW7K1tJKNgdtXC=uii7yg=UxZoOFhM8UTbWF+bFOWA@mail.gmail.com>
References: <1523734.6NloWteI3S@tata> <5154748.0thC7X2zN4@tata>
 <CAFcNs+qQvW7K1tJKNgdtXC=uii7yg=UxZoOFhM8UTbWF+bFOWA@mail.gmail.com>
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain; charset="iso-8859-1"
Precedence: bulk
Sender: pgsql-hackers-owner@postgresql.org

On Tuesday 01 of April 2014 11:06:00 you wrote:
> On Tue, Apr 1, 2014 at 9:13 AM, Andrzej Mazurkiewicz <
>=20
> andrzej@mazurkiewicz.org> wrote:
> > It seems that if the trigger is internal (tgisinternal =3D true) it is =
not
> > visible to the DROP TRIGGER command. So it cannot be deleted using DROP
> > TRIGGER command, although the dependency type is DEPENDENCY_AUTOMATIC
>=20
> Try using a quoted identifier:
>=20
> DROP TRIGGER "RI_ConstraintTrigger_c_19322" ON master;
>=20
> Regards,
>
> --
> Fabr=EDzio de Royes Mello
> Consultoria/Coaching PostgreSQL
Good Afternoon.

Sorry for my mistake. I have forgotten about modifications of names to lowe=
r=20
case.

The owner of a table can drop trigger using the command DROP TRIGGER.

However, where I can find information on philosophy of that approach.

For me internal triggers are marked isinternal not to be accessed using SQL=
=20
commands. Removing internals, f. e. FK triggers, by hand by a programmer an=
d=20
even by an administrator seems not to be a recommended practice.

Kind Regards
Andrzej Mazurkiewicz


--=20
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers