Trigger disactivation and SELECT WAITING - Mailing list pgsql-general

Hi,

I have a database with views that can take up to 2 hours to be
calculated.

During that time, it's not possible to run a function that inserts data
into the database, apparently because this function disactivates a
trigger while it runs, by deleting and creating the trigger again at the
end. (At least in 7.4.X database, this is the only solution, right?)

Running "ps -afxu" show that the process that tries to insert data gets
stuck in the "SELECT WAITING" state.

Is there a solution to this?

Thanks!

----------------------------------
Philippe Lang
Attik System