removing duplicated constraints

I was looking through my database schema and noticed that some foreign key
declarations were duplicated.  For example, I found this statement
occurred twice within my DDL:

alter table ports
    add foreign key (category_id)
       references categories (id) on update cascade on delete cascade;

I fixed up the DDL to remove the duplicates.  Then I turned to the 7.2
PostgreSQL database to examine that situation.  I noticed this
duplication:

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');

To my eye, those two contraints are identical.  Some may consider that as
a bug (i.e postgres allowing a FK to be duplicated).  I see it as a
feature, which in this case, has been misused.

From what I see, I can easily delete either one of these two constraints
without affecting the relational integrity of the database.  Do you agree?

This is how I'm going to identify the duplicate constraints.

$ pg_dump -s > fp2migration.ddl
$ grep "CREATE CONSTRAINT TRIGGER" ~/fp2migration.ddl  > constraints.txt
$ cat constraints.txt | sort | uniq > constraints.sorted.txt
$ wc -l constraints.txt
      93 constraints.txt
$ wc -l constraints.sorted.txt
      78 constraints.sorted.txt

It looks like I have 15 duplicated constraints to fix up.

Thanks
--
Dan Langille
The FreeBSD Diary - http://freebsddiary.org/ - practical examples