Tom Lane wrote:
Still and all, I will hold still for having it be installed by default as long as there is a simple way for the DBA to change that default --- let's say, roughly as simple as it is now for the DBA to make it the default if he wishes (ie "create language plpgsql" in template1) and revoke that again if he changes his mind ("drop language plpgsql" in template1). initdb-time switches are not an adequate answer, not least because most packagers don't make it easy to control them.
The way I intended to do it would indeed allow it to be undone simply by executing 'drop language plpgsql' in template1.
I'm not clear about what else you want. cheers andrew ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match