Re: [GENERAL] Creating and managing triggers

2012-10-09 Thread Dmitriy Igrishin
Hey, 2012/10/9 Tom Lane > Dean Myerson writes: > > 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

Re: [GENERAL] Creating and managing triggers

2012-10-08 Thread Tom Lane
Dean Myerson writes: > 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 compa

[GENERAL] Creating and managing triggers

2012-10-08 Thread Dean Myerson
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 thi