- 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)
1. Changed trigger functions from "opaque" to "trigger" to get rid of the warnings during initial install (only for acs-kernel, there are a lot elsewhere!)
2. Added "embeds" for postgresql and partially for oracle.
3. Added global parameters for postgresql and partially for oracle.