[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