Re: removing duplicated constraints

On 2 Mar 2002 at 10:19, Dan Langille wrote:

> CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER INSERT OR UPDATE ON "ports"
> FROM "categories" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE
> PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'ports', 'categories',
> 'UNSPECIFIED', 'category_id', 'id');
>
> CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER INSERT OR UPDATE ON "ports"
> FROM "categories" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE
> PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'ports', 'categories',
> 'UNSPECIFIED', 'category_id', 'id');

How is an unnamed trigger deleted?  During a dump, I can find information
such as this:

--
-- TOC Entry ID 211 (OID 998200)
--
-- Name: "RI_ConstraintTrigger_998199" Type: TRIGGER Owner: dan
--

How is that information useful to this situation?
--
Dan Langille
The FreeBSD Diary - http://freebsddiary.org/ - practical examples