Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 080B96345F9 for ; Wed, 9 Sep 2009 07:05:32 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 45974-06 for ; Wed, 9 Sep 2009 10:05:24 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from relay.pcl-ipout01.plus.net (relay.pcl-ipout01.plus.net [212.159.7.99]) by mail.postgresql.org (Postfix) with ESMTP id 79937633783 for ; Wed, 9 Sep 2009 07:05:23 -0300 (ADT) X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: ApoEAOcap0rUnw6T/2dsb2JhbADdLIItgWsF Received: from ptb-relay03.plus.net ([212.159.14.147]) by relay.pcl-ipout01.plus.net with ESMTP; 09 Sep 2009 11:05:20 +0100 Received: from [84.51.143.99] (helo=server3.office.archonet.com) by ptb-relay03.plus.net with esmtp (Exim) id 1MlK3D-0004Ug-It; Wed, 09 Sep 2009 11:05:19 +0100 Received: from [192.168.1.36] (dell36.office.archonet.com [192.168.1.36]) by server3.office.archonet.com (Postfix) with ESMTP id 533A7274069; Wed, 9 Sep 2009 11:05:11 +0100 (BST) Message-ID: <4AA77DD7.5040908@archonet.com> Date: Wed, 09 Sep 2009 11:05:11 +0100 From: Richard Huxton User-Agent: Thunderbird 2.0.0.23 (X11/20090817) MIME-Version: 1.0 To: Sridhar Reddy Ratna CC: pgsql-sql@postgresql.org Subject: Re: trigger failed to identify the partions References: <17DD0201A12947039313F26974E8E9B4@Sridharvisic> In-Reply-To: <17DD0201A12947039313F26974E8E9B4@Sridharvisic> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Plusnet-Relay: 3ce2ce1c97979192c9b4facd655fa9b4 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.999 tagged_above=-10 required=5 tests=BAYES_50=0.001, RCVD_IN_DNSWL_LOW=-1 X-Spam-Level: X-Archive-Number: 200909/34 X-Sequence-Number: 33099 Sridhar Reddy Ratna wrote: > > dateTable := coll_fp_subdtls_01; > > ELSE > > dateTable := coll_fp_subdtls_02; > ERROR: column "coll_fp_subdtls_01" does not exist > > ERROR: column "coll_fp_subdtls_01" does not exist I think you missed the word "column" in the error message (easy to do, you know you are naming tables). You've missed the quotes around the partition-names so it's trying to find a column on a table that matches. dateTable := 'coll_fp_subdtls_01'; -- Richard Huxton Archonet Ltd