On 8/21/07, Jon Collette <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
