pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedTable Partition
4+ messages / 3 participants
[nested] [flat]
* Table Partition
@ 2014-08-28 08:30 Saravanan.S <saravanan.s@sodtechnologies.com>
0 siblings, 2 replies; 4+ messages in thread
From: Saravanan.S @ 2014-08-28 08:30 UTC (permalink / raw)
To: pgsql-admin
Hi,
I created the partition for existing table, its working fine.
but the problem is it is creating two records in master table. i don't
know what i did wrong..
Thanks & Regards
Saravanan S
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Table Partition
@ 2014-08-28 14:12 Matheus de Oliveira <matioli.matheus@gmail.com>
parent: Saravanan.S <saravanan.s@sodtechnologies.com>
1 sibling, 0 replies; 4+ messages in thread
From: Matheus de Oliveira @ 2014-08-28 14:12 UTC (permalink / raw)
To: saravanan.s@sodtechnologies.com; +Cc: pgsql-admin
On Thu, Aug 28, 2014 at 5:30 AM, Saravanan.S <
saravanan.s@sodtechnologies.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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Table Partition
@ 2014-08-28 14:17 Atıf CEYLAN <mehmet@atifceylan.com>
parent: Saravanan.S <saravanan.s@sodtechnologies.com>
1 sibling, 0 replies; 4+ messages in thread
From: Atıf CEYLAN @ 2014-08-28 14:17 UTC (permalink / raw)
To: pgsql-admin
On 08/28/2014 11:30 AM, Saravanan.S wrote:
> Hi,
> I created the partition for existing table, its working fine.
> but the problem is it is creating two records in master table. i don't
> know what i did wrong..
> Thanks & Regards
> Saravanan S
Can you send your insert sql or table structure ?
Is there a trigger on inherited tables?
--
M.Atıf CEYLAN
Yurdum Yazılım
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Table Partition
@ 2014-08-29 05:46 Saravanan.S <saravanan.s@sodtechnologies.com>
0 siblings, 0 replies; 4+ messages in thread
From: Saravanan.S @ 2014-08-29 05:46 UTC (permalink / raw)
To: Matheus de Oliveira <matioli.matheus@gmail.com>; +Cc: pgsql-admin
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@postgresql.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 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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2014-08-29 05:46 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2014-08-28 08:30 Table Partition Saravanan.S <saravanan.s@sodtechnologies.com>
2014-08-28 14:12 ` Matheus de Oliveira <matioli.matheus@gmail.com>
2014-08-28 14:17 ` Atıf CEYLAN <mehmet@atifceylan.com>
2014-08-29 05:46 Re: Table Partition Saravanan.S <saravanan.s@sodtechnologies.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox