Thanks Matheus, its working fine now.
From: "Matheus de Oliveira" <matioli.matheus@xxxxxxxxx>
Sent: Thursday, August 28, 2014 7:50 PM
To: saravanan.s@xxxxxxxxxxxxxxxxxxx
Cc: "pgsql-admin@xxxxxxxxxxxxxx" <pgsql-admin@xxxxxxxxxxxxxx>
Subject: Re: Table Partition
Sent: Thursday, August 28, 2014 7:50 PM
To: saravanan.s@xxxxxxxxxxxxxxxxxxx
Cc: "pgsql-admin@xxxxxxxxxxxxxx" <pgsql-admin@xxxxxxxxxxxxxx>
Subject: Re: Table Partition
On Thu, Aug 28, 2014 at 5:30 AM, Saravanan.S <saravanan.s@xxxxxxxxxxxxxxxxxxx> 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
Matheus de Oliveira
Analista de Banco de Dados
Dextra Sistemas - MPS.Br nível F!
www.dextra.com.br/postgres