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.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