Postgres Pro
Downloads
Home   >   mailing lists

Re: Update INSERT RULE while running for Partitioning - Mailing list pgsql-performance

From Markus Schaber
Subject Re: Update INSERT RULE while running for Partitioning
Date
Msg-id 44AE1C5B.3000300@logix-tt.com
Whole thread Raw
In response to Update INSERT RULE while running for Partitioning  (Gene <genekhart@gmail.com>)
List pgsql-performance
Tree view 
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 count
> on the last rule which gives Hibernate problems.

This could be considered a PostgreSQL bug - maybe you should discuss
this on the appropriate list (general, hackers)?


HTH,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org

pgsql-performance by date:

Previous
From: Markus Schaber
Date:
Subject: Re: need vacuum after insert/truncate/insert?
Next
From: Hripchenko Sergey
Date:
Subject: longest prefix match querries