Hi,

I had a problem, that I was unable to drop a constraint trigger.

1. Why do constraint trigger loose their name and get RI_ConstrainTrigger_NNNN?
2. Why do you need the double quotes around "RI_ConstrainTrigger_..."?

foo_foo_mwtest=# create constraint trigger hist_trigger after insert or update or delete on foo_historytransaction
DEFERRABLE INITIALLY DEFERRED for each row execute procedure do_raise();
CREATE TRIGGER

foo_foo_mwtest=# \d foo_historytransaction
Tabelle »public.foo_historytransaction«
Spalte | Typ | Attribute
--------------+--------------------------+-------------------------------------------------------------------------
id | integer | not null default nextval('foo_historytransaction_id_seq'::regclass)
date | timestamp with time zone | not null
changedby_id | integer | not null
Indexe:
»foo_historytransaction_pkey« PRIMARY KEY, btree (id)
»foo_historytransaction_changedby_id« btree (changedby_id)
Fremdschlüssel-Constraints:
»foo_historytransaction_changedby_id_fkey« FOREIGN KEY (changedby_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY
DEFERRED
Trigger:
"RI_ConstraintTrigger_53828" AFTER INSERT OR DELETE OR UPDATE ON foo_historytransaction DEFERRABLE INITIALLY
DEFERRED FOR EACH ROW EXECUTE PROCEDURE do_raise()

foo_foo_mwtest=# drop trigger RI_ConstraintTrigger_53828 on foo_historytransaction;
ERROR: Trigger »ri_constrainttrigger_53828« for table »foo_historytransaction« does not exist.

foo_foo_mwtest=# drop trigger "RI_ConstraintTrigger_53828" on foo_historytransaction;
DROP TRIGGER

foo_foo_mwtest=# select version();
PostgreSQL 8.2.6 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.2.1 (SUSE Linux)


--
Thomas Guettler, http://www.thomas-guettler.de/
E-Mail: guettli (*) thomas-guettler + de

Hi Thomas,

Thomas Guettler schrieb:
the namespace is case-sensitive and unquoted names will be lowercased as
You already have discoverd.


....
Regards,
Nico

Hi Thomas,

Thomas Guettler schrieb:
the namespace is case-sensitive and unquoted names will be lowercased as
You already have discoverd.


....
Regards,
Nico

Hi Thomas,

Thomas Guettler schrieb:
the namespace is case-sensitive and unquoted names will be lowercased as
You already have discoverd.


....
Regards,
Nico

Hi Thomas,

Thomas Guettler schrieb:
the namespace is case-sensitive and unquoted names will be lowercased as
You already have discoverd.


....
Regards,
Nico

Hi Thomas,

Thomas Guettler schrieb:
the namespace is case-sensitive and unquoted names will be lowercased as
You already have discoverd.


....
Regards,
Nico

Hi Thomas,

Thomas Guettler schrieb:
the namespace is case-sensitive and unquoted names will be lowercased as
You already have discoverd.


....
Regards,
Nico

Hi Thomas,

Thomas Guettler schrieb:
the namespace is case-sensitive and unquoted names will be lowercased as
You already have discoverd.


....
Regards,
Nico

Hi Thomas,

Thomas Guettler schrieb:
the namespace is case-sensitive and unquoted names will be lowercased as
You already have discoverd.


....
Regards,
Nico