Re: Indexes on inheriting tables

On 25/08/11 12:10, Shoaib Mir wrote:
> On Thu, Aug 25, 2011 at 11:57 AM, Toby Corkindale
> <toby(dot)corkindale(at)strategicdata(dot)com(dot)au
> <mailto:toby(dot)corkindale(at)strategicdata(dot)com(dot)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