[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] Enable?Disable Trigger
From:       Kevin Neufeld <kneufeld () refractions ! net>
Date:       2009-10-29 0:54:26
Message-ID: 4AE8E7C2.6070408 () refractions ! net
[Download RAW message or body]

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@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>   
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]