Hi, I meant: in 7.4.X databases, is there a way of disabling a trigger without deleting it? I guess the answer is no.
That's what my plpgsql insert function does, and because of this, if a view is running at the same moment on the same tables (some views can take up to 2 hours to be calculated), the insert function gets stuck in a SELECT WAITING state. So insertions are impossible in the database when views are being calculated. Regards, -----Message d'origine----- De : Tom Lane [mailto:[EMAIL PROTECTED] Envoyé : mardi, 26. juillet 2005 15:14 À : Philippe Lang Cc : pgsql-general@postgresql.org Objet : Re: [GENERAL] Trigger disactivation and SELECT WAITING "Philippe Lang" <[EMAIL PROTECTED]> writes: > 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?) "Only solution" to what? Why in the world would a view fool around with removing triggers? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
