Re: Generic function for partitioning function? - Mailing list pgsql-general

From Martin Collins
Subject Re: Generic function for partitioning function?
Date
Msg-id 52267923.7060007@mkcollins.org
Whole thread Raw
In response to Generic function for partitioning function?  (Gregory Haase <haaseg@onefreevoice.com>)
List 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



pgsql-general by date:

Previous
From: Giuseppe Broccolo
Date:
Subject: Re: FETCH FORWARD 0 and "cursor can only scan forward" error
Next
From: Trigve Siver
Date:
Subject: Re: FETCH FORWARD 0 and "cursor can only scan forward" error