[phpOpenTracker-User] Postgresql trigger creation missing

Hi Sebastian, I *just* noticed that the new postgresql SQL file has the 
new trigger function definitions *but* is missing the trigger creation!

For each trigger function defined we also need to have the following 
type of trigger creation line:

create trigger pot_documents_duplicate_check_trig BEFORE INSERT ON 
pot_documents
   for each ROW EXECUTE PROCEDURE pot_documents_duplicate_check();

create trigger pot_hostnames_duplicate_check_trig BEFORE INSERT ON 
pot_documents
   for each ROW EXECUTE PROCEDURE pot_hostnames_duplicate_check();

create trigger pot_operating_systems_duplicate_check_trig BEFORE INSERT 
ON pot_documents
   for each ROW EXECUTE PROCEDURE pot_operating_systems_duplicate_check();

create trigger pot_referers_duplicate_check_trig BEFORE INSERT ON 
pot_documents
   for each ROW EXECUTE PROCEDURE pot_referers_duplicate_check();

create trigger pot_user_agents_duplicate_check_trig BEFORE INSERT ON 
pot_documents
   for each ROW EXECUTE PROCEDURE pot_user_agents_duplicate_check();


Sorry for not noticing this earlier!

Jean-Christian Imbeault



-------------------------------------------------------
This SF.net email is sponsored by: VM Ware
With VMware you can run multiple operating systems on a single machine.
WITHOUT REBOOTING! Mix Linux / Windows / Novell virtual machines at the
same time. Free trial click here: http://www.vmware.com/wl/offer/345/0