Question about partitioning - Mailing list pgsql-general

From Devrim GUNDUZ
Subject Question about partitioning
Date
Msg-id 1145277814.2845.7.camel@laptop.gunduz.org
Whole thread Raw
Responses Re: Question about partitioning  (Devrim GUNDUZ <devrim@commandprompt.com>)
List pgsql-general
Hi,

I am writing a tutorial (in Turkish) on partitioning and I have a
question that I could not find the answer of.

http://www.postgresql.org/docs/8.1/static/ddl-partitioning.html

This doc suggests to write a rule in order to be sure that data is
entered to the latest partition. Also it says that we need to redefine
this rule every month (based on the example there).

So the question is: What if we forget to redefine this? Data will not be
entered to the table defined in the rule because the check constraint
will not allow this.

So, is there a better solution than running a cron job (which redefines
this rule) at the first second of each month?

Regards,
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: PL/php, plPerlNG - http://www.commandprompt.com/



pgsql-general by date:

Previous
From: "surabhi.ahuja"
Date:
Subject: catch SQLException, error code for Foeign key violation,
Next
From: Devrim GUNDUZ
Date:
Subject: Re: Question about partitioning