[postgis-users] Enable?Disable Trigger

Kevin Neufeld kneufeld at refractions.net
Wed Oct 28 17:54:26 PDT 2009


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 at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>   



More information about the postgis-users mailing list