Re: [GENERAL] Table Partitioning

2013-05-22 Thread Richard Onorato
partition.  Thus I end up with 120 records when I am expecting just 60. Any ideas on how I can fix this issue?   Regards, Richard From: Richard Onorato To: Raghavendra Cc: "pgsql-general@postgresql.org" Sent: Wednesday, May 22, 2013 7:27 PM S

Re: [GENERAL] Table Partitioning

2013-05-22 Thread Richard Onorato
Raghavendra, I am doing my inserts via Java JPA statements embedded in my Data Access Layer.  I can share them if you would like to see them.   Regards, Richard From: Raghavendra To: Richard Onorato Cc: "pgsql-general@postgresql.org" Sent:

Re: [GENERAL] Table Partitioning

2013-05-21 Thread Richard Onorato
-increment supported on table partitioning?   Regards, Richard From: Raghavendra To: Richard Onorato Cc: "pgsql-general@postgresql.org" Sent: Tuesday, May 21, 2013 1:06 PM Subject: Re: [GENERAL] Table Partitioning On Tue, May 21, 2013 at 11:03 P

Re: [GENERAL] Table Partitioning

2013-05-21 Thread Richard Onorato
Interesting. I wonder what I am doing wrong. I will try and setup the database again and see if I can get it to work. thank you for testing it out for me. Richard On May 21, 2013, at 1:06 PM, Raghavendra wrote: > On Tue, May 21, 2013 at 11:03 PM, Richard Onorato > wrote: > I a

[GENERAL] Table Partitioning

2013-05-21 Thread Richard Onorato
I am wanting to partition my data based on a mod of one of the bigint columns, but when I run my insert test all the data goes into the base table and not the partitions.  Here is what the table looks like: CREATE table MyMappingTable ( id bigserial NOT NULL,