Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 8777B9FA069 for ; Tue, 21 Aug 2007 18:51:17 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 12396-04-3 for ; Tue, 21 Aug 2007 18:51:11 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.244]) by postgresql.org (Postfix) with ESMTP id 8A7589FA05F for ; Tue, 21 Aug 2007 18:51:11 -0300 (ADT) Received: by an-out-0708.google.com with SMTP id c36so164488ana for ; Tue, 21 Aug 2007 14:51:10 -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=ZCMvySRS2oJ2f1fLrw8lmuJs5XSCyJdK3vvep35FOrny5Eske6a6takz0VZmIp8egwUYMEmRndzkss5Gksl9JIc0hzU1Z77FMoxWioQBrrj3Q508gF5VpkV348msxrfZXnCtx1Q5hKivlmQdRnOjJzH4+Q4xGtWfF9zhhhjXduA= 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=cR22SsE9zJky97+sxwXAskBQJxuls/9YXD/O5RcQJIXXiLgkXwuotxG6kDZj3l9xmu0AshOvZ1NDD2FK1nn8NfOj32Ic+qGcmZ2od0Gzq6xZNSGLXF8BYz7h0ISnUtnkI0LZPI/1SL3O6HhDUM951sCqM46+S65GzRsb2Buw3ZE= Received: by 10.90.75.10 with SMTP id x10mr3008856aga.1187733069630; Tue, 21 Aug 2007 14:51:09 -0700 (PDT) Received: by 10.100.33.20 with HTTP; Tue, 21 Aug 2007 14:51:09 -0700 (PDT) Message-ID: Date: Tue, 21 Aug 2007 16:51:09 -0500 From: "=?UTF-8?Q?Rodrigo_De_Le=C3=B3n?=" To: "Jon Collette" Subject: Re: Make a SQL statement not run trigger Cc: pgsql-sql@postgresql.org In-Reply-To: <46CB5876.80003@etelos.com> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <46CB5876.80003@etelos.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/174 X-Sequence-Number: 29112 On 8/21/07, Jon Collette wrote: > Is it possible to run an insert,update, or delete and have it not launch > a trigger like it normally would? alter table disable trigger ... http://www.postgresql.org/docs/8.2/static/sql-altertable.html