On 25/08/11 12:10, Shoaib Mir wrote:
> On Thu, Aug 25, 2011 at 11:57 AM, Toby Corkindale
> <toby.corkindale@strategicdata.com.au
> <mailto:toby.corkindale@strategicdata.com.au>> wrote:
>
>
> It seems messy to inherit the columns but not the indexes or checks
> upon them :(
>
>
>
> Yes it can be a bit annoying at timse but you can try to automate the
> whole process as well. Like I found this blog entry -->
> http://blog.inovia.fr/auto-partitioning-on-postgresql-part-1/
As far as I could tell, that isn't automating anything to do with
indexes or checks on the child tables?
Although using a trigger to automate the creation of the child table
itself is still nifty. I hadn't thought of that.
thanks,
Toby
