Re: Make a SQL statement not run trigger

On 8/21/07, Jon Collette <jon(at)etelos(dot)com> wrote:
> I think this will work for what I need. I have been messing around with
> this using select into
>
> /select True as donothing into temporary table table_trigger_name;
> then run statement that I want to be ignored
> /
> The trigger would have a select upon the table_trigger_name to determine
> if it should run or not. I am having issues catching the exception when
> the table is not found.
>

Note that if you use temp tables much, you need to make sure that
autovacuum is up and running (or vacuum regularly) to keep the system
catalogs from getting bloated. Just FYI.