Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 280BC9F9F51 for ; Tue, 21 Aug 2007 20:01:29 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 70954-04 for ; Tue, 21 Aug 2007 20:01:26 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from rv-out-0910.google.com (rv-out-0910.google.com [209.85.198.189]) by postgresql.org (Postfix) with ESMTP id 33ED59F9F20 for ; Tue, 21 Aug 2007 20:01:26 -0300 (ADT) Received: by rv-out-0910.google.com with SMTP id l15so1273538rvb for ; Tue, 21 Aug 2007 16:01:24 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=tbrI+ozxcCb4SOo8lae/kXp61M8sv0coQ1+lG4QYDc88Ox9doV8lUpPikNbXF8xl0+lhCs9PWYVlXzUxjTnHBTly12sB0SXl5Xe4XR2GXg63v4PSpSMW9c4cxFy97frZh5m/479+tvKPPP8vgVcVfWezrrvyVgQyVo3nE968zlY= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=SUoQjrIW6dc5hK7YY3E1hhI0kK6SL6N8rQcFXOlZNlRF3vR/MKX9sTxDJClLwE90Yj3rASNovPU1muSXEXw6WRPC5HFFa6BNTRUvqPAZ/Lxk1KyLJbeuVSlqgtZ61CUy6A7iww7tBlGWlMYzRiYumnwQ3KCmMGc1NmSrHZgQS3w= Received: by 10.140.250.14 with SMTP id x14mr3693700rvh.1187737284715; Tue, 21 Aug 2007 16:01:24 -0700 (PDT) Received: by 10.141.98.12 with HTTP; Tue, 21 Aug 2007 16:01:24 -0700 (PDT) Message-ID: Date: Tue, 21 Aug 2007 18:01:24 -0500 From: "Scott Marlowe" To: "Jon Collette" Subject: Re: Make a SQL statement not run trigger Cc: pgsql-sql@postgresql.org In-Reply-To: <46CB6C0E.7070508@etelos.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <46CB5876.80003@etelos.com> <46CB6C0E.7070508@etelos.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/180 X-Sequence-Number: 29118 On 8/21/07, Jon Collette 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.