- Avoiding usage of coalesce function on site_nodes table columns in WHERE clause, this was leading to usage of sequencial scans which can be expensive when having a huge amount of site_nodes. Instead we go for isolation of the case when requestion a node with a null parent ( this would be the main site node ) and we use the = operator so the planner goes for a index scan. - Adding not null constraint to site_nodes(name)
Merged oacs-5-6 to HEAD. HEAD now installs and passes all core tests. There may still be some lingering problems due to my screwing up the oacs-5-6 branch earlier, I'll be looking into this later.