Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XNOjf-0005LL-6t for pgsql-admin@arkaria.postgresql.org; Fri, 29 Aug 2014 16:09:11 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1XNOje-0004KY-5b for pgsql-admin@arkaria.postgresql.org; Fri, 29 Aug 2014 16:09:10 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1XNFFw-0000JA-8i for pgsql-admin@postgresql.org; Fri, 29 Aug 2014 06:01:52 +0000 Received: from mail.urolime.com ([67.212.189.50]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XNFFq-000672-Ty for pgsql-admin@postgresql.org; Fri, 29 Aug 2014 06:01:50 +0000 DomainKey-Signature: a=rsa-sha1; c=nofws; q=dns; d=sodtechnologies.com; s=sodtech; h=received:from:to:cc:subject:date:reply-to:message-id:mime-version :content-type:x-originating-ip; b=fmiFXeZKWDIridbAIa25ZZ4CW2VyCOiN9KGUZhWdpPin1BswgKE/yPPoH9LFDn2vo Wbe25bhGTcr4oSxdp4x0UoURNGMLxjS6hafOCpUV0X12++DWpBmg8iFzCrIqoRQh/ mrsbB+EGijMk/qJUss+MocBdrl5nESrUJBJeqTMo8= DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=sodtechnologies.com; s=sodtech; h=x-originating-ip:content-type:mime-version:message-id:reply-to :date:subject:cc:to:from; bh=WkFlxnxIhhZqzJLbTFKWwJKQSXHPU0bjbCclY5Wl4e4=; b=dFV/dhEy4BphNKT53vdN8jlo8HuyLNj+2OvEo130MX4TWtAzlnqIkyWD4rvESyc/I ljH11Pcjj+kOWprhsack6IhIBXPQpda0wzKAnFuVM2mxxSd1fnhyKqSIphwus7gWl woxn1TjlCFoAr3vnHiDJtpH9cbvuI6yJUjMtgocm0= Received: by mail.urolime.com via HTTP; Fri, 29 Aug 2014 11:16:28 +0530 From: "Saravanan.S" To: "Matheus de Oliveira" CC: "pgsql-admin@postgresql.org" Subject: Re: Table Partition Date: Fri, 29 Aug 2014 11:16:28 +0530 Reply-To: saravanan.s@sodtechnologies.com Message-ID: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=962a560b66df40c8a47974845f02da9a X-Originating-IP: [14.140.179.218] X-Pg-Spam-Score: -2.0 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org This is a multipart message in MIME format. --962a560b66df40c8a47974845f02da9a Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Thanks Matheus, its working fine now. ---------------------------------------- From: "Matheus de Oliveira" Sent: Thursday, August 28, 2014 7:50 PM To: saravanan.s@sodtechnologies.com Cc: "pgsql-admin@postgresql.org" Subject: Re: [ADMIN] Table Partition On Thu, Aug 28, 2014 at 5:30 AM, Saravanan.S wrote: but the problem is it is creating two records in master tab= le. i don't know what i did wrong.. You possible did the redirect trigger function wrong. It should be a befor= e trigger that returns NULL. Regards, -- Matheus de Oliveira Analista de Banco de Dados Dextra Sistemas - MPS.Br n=EDvel F! www.dextra.com.br/postgres --962a560b66df40c8a47974845f02da9a Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable =
Thanks Matheus, its working fine now.
 
 
 
 
 
From: "Matheus de Oliveira" <matioli.matheus@gmail.com= >
Sent: Thursday, August 28, 2014 7:50 PM
To: saravanan.s@sodtechnologies.com
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresq= l.org>
Subject: Re: [ADMIN] Table Partition
 
 
On Thu, Aug 28, 2014 at 5:30 AM, Saravanan.S <saravanan.s@sodtechnologies.com> wrote:
but the problem is it is creating two record= s in master table. i don't know what i did wrong..

 
You possible did the redirect trigger function w= rong. It should be a before trigger that returns NULL.
 
Regards,
--
Matheus de Oliveira
Analista de Banco de Dados
Dextra Sistemas - MPS.Br nível F!
www.dextra= .com.br/postgres
 
 --962a560b66df40c8a47974845f02da9a--