Ensure datistemplate is true for template_postgis

[pramsey]

For the template_postgis created by the Windows installer, it's important that the datistemplate flag is set so that non-superusers can clone the template.

 http://postgis.refractions.net/pipermail/postgis-devel/2009-June/006059.html

[pramsey]

update pg_database set datistemplate = true 
  where datname = 'template_postgis';

[robe]

The logic was in the script. Took us a while to figure out why it wasn't working. Was exiting at the createlang step so never did the update template step since the newer versions of PostgreSQL I guess already have plpgsql installed in the base template.

We also added in packaging of the shp2pgsqlgui loader and a prompt to overwrite the plugins.ini. It really doesn't do much on PostgreSQL 8.3 since the PgAdmin? III packaged with 8.3 doesn't support the plugins architecture. Please check and see if this makes logical sense to everyone.

Anyrate if you want to give it a try before we officially upload to stackbuilder and link on site.

 http://www.postgis.org/download/windows/pg84/postgis-pg84-setup-1.5.0-1.exe  http://www.postgis.org/download/windows/pg83/postgis-pg83-setup-1.5.0-1.exe

We still plan to test on a couple other machines before we officially deploy.

Thanks, Regina and Leo