Re: Trigger disactivation and SELECT WAITING - Mailing list pgsql-general

From Tom Lane
Subject Re: Trigger disactivation and SELECT WAITING
Date
Msg-id 26888.1122383662@sss.pgh.pa.us
Whole thread Raw
In response to Trigger disactivation and SELECT WAITING  ("Philippe Lang" <philippe.lang@attiksystem.ch>)
List pgsql-general
"Philippe Lang" <philippe.lang@attiksystem.ch> 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

pgsql-general by date:

Previous
From: "Filip Wuytack"
Date:
Subject: Hardware suggestions for a new data warehouse Postgresql/Bizgres server? (£6000)
Next
From: "Sim Zacks"
Date:
Subject: Access FE - This operation is not supported within transaction