On 25/08/11 12:10, Shoaib Mir wrote:
On Thu, Aug 25, 2011 at 11:57 AM, Toby Corkindale
<toby.corkind...@strategicdata.com.au
<mailto:toby.corkind...@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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general