Re: [PERFORM] Update INSERT RULE while running for Partitioning

2006-07-07 Thread Dave Chapeskie
On Fri, Jul 07, 2006 at 03:51:38AM -0400, Gene wrote: > Starting off with: > > Parent (Rule on insert instead insert into Child2) > Child1 (Constraint date <= somedate1) > Child2 (Constraint date > somedate1) > > Now I want to create another Partition: > > Create Table Child3 > BEGIN > Update

Re: [PERFORM] Update INSERT RULE while running for Partitioning

2006-07-07 Thread Markus Schaber
Hi, Gene, Gene wrote: > I'm using PostgreSQL 8.1.4 in a Hibernate Application and I am > attempting to use partitioning via Inherited tables. At first I was > going to create a rule per sub-table based on a date range, but found > out with multiple rules postgres will only return the affected-row

[PERFORM] Update INSERT RULE while running for Partitioning

2006-07-07 Thread Gene
I'm using PostgreSQL 8.1.4 in a Hibernate Application and I am attempting to use partitioning via Inherited tables. At first I was going to create a rule per sub-table based on a date range, but found out with multiple rules postgres will only return the affected-row count on the last rule which gi