Re: Table Partition

Thanks Matheus, its working fine now.

----------------------------------------

From: "Matheus de Oliveira" <matioli(dot)matheus(at)gmail(dot)com>
Sent: Thursday, August 28, 2014 7:50 PM
To: saravanan(dot)s(at)sodtechnologies(dot)com
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: [ADMIN] Table Partition
On Thu, Aug 28, 2014 at 5:30 AM, Saravanan.S <saravanan(dot)s(at)sodtechnologies(dot)com> wrote: but the problem is it is creating two records in master table. i don't know what i did wrong..

You possible did the redirect trigger function wrong. 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