Re: Generic function for partitioning function?

From: Martin Collins <martin(at)mkcollins(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Generic function for partitioning function?
Date: 2013-09-04 00:04:51
Message-ID: 52267923.7060007@mkcollins.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 09/03/2013 04:38 PM, Gregory Haase wrote:
>
> So, my conclusion is that the generic function will work, and it will
> make administration (even automated administration) of partitioned
> tables much simpler.
>
> My question is... Is there a compelling reason why I should NOT do
> this. I must confess, it seems so straightforward that I feel like I
> must be missing something.

I do something similar with my OpenERP setup. The only caveat I have is
that foreign key constraints don't work with partitioned tables.

Martin

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2013-09-04 02:06:49 Re: store multiple rows with the SELECT INTO statement
Previous Message Gregory Haase 2013-09-03 22:38:06 Generic function for partitioning function?