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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
