Enable?Disable Trigger

[Bob Pawley]

Some parts of this message have been removed. Learn more about Nabble's security policy.

Hi

 

I'm considering using

 

'alter table graphics.fluids_devices disable trigger f_d_trigger'

 

to control the trigger function during a transaction.

 

Are there any long term problems associated with doing this??

 

Bob

_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users

[Kevin Neufeld]

The only thing that comes to mind is that the ALTER TABLE command will
perform a complete table lock on the table for the duration of the
transaction -  implying that any other transaction won't be able to
select from your table until the transaction finishes.
-- Kevin

Bob Pawley wrote:

> Hi
>  
> I'm considering using
>  
> 'alter table graphics.fluids_devices disable trigger f_d_trigger'
>  
> to control the trigger function during a transaction.
>  
> Are there any long term problems associated with doing this??
>  
> Bob
> ------------------------------------------------------------------------
>
> _______________________________________________
> postgis-users mailing list
> postgis-users@...
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>  

_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users