Thread: Question about partitioning
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/
Hi, On Mon, 2006-04-17 at 15:43 +0300, Devrim GUNDUZ wrote: > I have a question that I could not find the answer of. Next time I'll scroll down a bit to find my answer. Sorry for the noise. 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/