I need to create some triggers and the docs seem pretty straightforward.
When I tried to create one using CREATE TRIGGER, it took over 20
minutes, and the second one hadn't finished over more than an hour. And
I later found that all other database users in the company were locked
out during this process. The table getting the triggers has about 187000
rows in it and is pretty central, so lots of functions join with it.
So the first question is whether it is normal for a Create Trigger
command to take so long. Also, I don't see any commands to examine
existing triggers. They restarted the database server when the second
create trigger hung, so I don't know what happened with it. I didn't
even save the name, obviously a problem on my part. But there should be
some equivalent of Show Trigger, shouldn't there?
Dean