How do I drop a Complicated Constraint Trigger After Delete Execute Procedure?

Hi,

Hmm. Things are still getting interesting around here.

Here is my complicated problem.  I tried to delete a user from my users table, but it said
"ERROR:  bug_assigned_to_fk referential integrity violation - key in users still referenced from bug"
Ok.
Then I saw this statement in the .sql file.
"CREATE CONSTRAINT TRIGGER "bug_assigned_to_fk" AFTER DELETE ON "users"  FROM "bug" NOT DEFERRABLE INITIALLY IMMEDIATE
FOREACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('bug_assigned_to_fk', 'bug', 'users', 'FULL', 'assigned_to',
'user_id');"
Then I used this command to delete the constraint trigger:
" drop trigger bug_assign_to_fk on bug;"
I received error:
"ERROR:  DropTrigger: there is no trigger bug_assign_to_fk on relation bug"
I also tried
"drop trigger bug_assign_to_fk on user;"
I received this error:
"ERROR:  DropTrigger: there is no trigger bug_assign_to_fk on relation users"

Here is the bug table.  Please NOTE there is no constraint listed in the bug table.

\d bug
                              Table "bug"
   Attribute   |  Type   |                   Modifier
---------------+---------+----------------------------------------------
 bug_id        | integer | not null default nextval('bug_pk_seq'::text)
 group_id      | integer | not null default '0'
 status_id     | integer | not null default '0'
 priority      | integer | not null default '0'
 category_id   | integer | not null default '0'
 submitted_by  | integer | not null default '0'
 assigned_to   | integer | not null default '0'
 date          | integer | not null default '0'
 summary       | text    |
 details       | text    |
 close_date    | integer |
 bug_group_id  | integer | not null default '0'
 resolution_id | integer | not null default '0'
Indices: bug_group_id,
         bug_groupid_assignedto_statusid,
         bug_groupid_statusid,
         bug_pkey

Any ideas on how can I drop the bug_assigned_to_fk trigger so that I can remove an user?

Any help is appreciated.
Mary