triggers in background
Posted on 2004-08-24
in postgresql 7.x,
is there a way to run trigger in background mode ?
What I need is :
- When a table insert/update/delete, my trigger is running immediately.
But I don't want to wait for trigger's result. My function/procedure will return, trigger will continue to run, even it successfull or not.
Scenerio is something like this.
- I call a function
- The functions inserts or updates a table.
- Trigger relaled to this table fired AFTER INSERT/UPDATE
- Trigger return RETURN NEW always. But need to be do some works during.
I don't care these works ended or not.
In this scenerio, since trigger running, my function which has been insert/update the table does NOT return.
I I want it to be finished as soon as possible. after INSERT/UPDATE without waiting trigger's operation.