Re: Update INSERT RULE while running for Partitioning

From: Markus Schaber <schabi(at)logix-tt(dot)com>
To: genekhart(at)gmail(dot)com
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Update INSERT RULE while running for Partitioning
Date: 2006-07-07 08:33:31
Message-ID: 44AE1C5B.3000300@logix-tt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Hripchenko Sergey 2006-07-07 08:48:49 longest prefix match querries
Previous Message Markus Schaber 2006-07-07 08:32:07 Re: need vacuum after insert/truncate/insert?