Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 1A8A4650EB9 for ; Wed, 2 Jul 2008 14:36:30 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 22251-09 for ; Wed, 2 Jul 2008 14:36:15 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from n70.bullet.mail.sp1.yahoo.com (n70.bullet.mail.sp1.yahoo.com [98.136.44.38]) by postgresql.org (Postfix) with SMTP id D161E650E2E for ; Wed, 2 Jul 2008 14:36:12 -0300 (ADT) Received: from [216.252.122.218] by n70.bullet.mail.sp1.yahoo.com with NNFMP; 02 Jul 2008 17:36:10 -0000 Received: from [68.142.200.221] by t3.bullet.sp1.yahoo.com with NNFMP; 02 Jul 2008 17:36:10 -0000 Received: from [76.13.13.26] by t9.bullet.mud.yahoo.com with NNFMP; 02 Jul 2008 17:36:10 -0000 Received: from [76.13.10.179] by t3.bullet.mail.ac4.yahoo.com with NNFMP; 02 Jul 2008 17:36:10 -0000 Received: from [127.0.0.1] by omp120.mail.ac4.yahoo.com with NNFMP; 02 Jul 2008 17:36:10 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 292475.84871.bm@omp120.mail.ac4.yahoo.com Received: (qmail 35008 invoked by uid 60001); 2 Jul 2008 17:36:10 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Received:X-Mailer:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Message-ID; b=BxiskrRtwomAcXRtdGmn3yNT9QjSD5YEROnYCDEVHUvM1MP0exXPgF0Z5b27ZNtFcBis6bd87A4aQGegvrTEvpHTuV5lhaz1YG/vIN9RP3Qg35nSk/82Emwf/yEm3h9zCZc4hrxz7RSifOc8Gxb3+FUK3FQDTL17WYOPrV+zGKI=; Received: from [209.88.228.11] by web59503.mail.ac4.yahoo.com via HTTP; Wed, 02 Jul 2008 10:36:10 PDT X-Mailer: YahooMailWebService/0.7.199 Date: Wed, 2 Jul 2008 10:36:10 -0700 (PDT) From: Lennin Caro Reply-To: lennin.caro@yahoo.com Subject: Re: Query To: pgsql-admin@postgresql.org, kartik In-Reply-To: <4868adac.1b068e0a.5de9.ffffadba@mx.google.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Message-ID: <70234.33587.qm@web59503.mail.ac4.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.139 tagged_above=0 required=5 tests=AWL=-0.049, RCVD_IN_BL_SPAMCOP_NET=2.188 X-Spam-Level: ** X-Archive-Number: 200807/34 X-Sequence-Number: 29644 --- On Mon, 6/30/08, kartik wrote: > From: kartik > Subject: [ADMIN] Query > To: pgsql-admin@postgresql.org > Date: Monday, June 30, 2008, 9:55 AM > Hello , > > I am a beginner for postgresql. I want to activate a > constraint for some > time and after that I want to deactivate it. > > > > Or > > > > I want to know whether a particular constraint exists and > whether its > activated or not. > > > > Waiting for yr reply triggers and status select tgname,tgenabled from pg_trigger