On 25/08/11 12:10, Shoaib Mir wrote:
On Thu, Aug 25, 2011 at 11:57 AM, Toby Corkindale <toby.corkindale@xxxxxxxxxxxxxxxxxxxx <mailto:toby.corkindale@xxxxxxxxxxxxxxxxxxxx>> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
