postgis.sql install script is noisy with NOTICES

[pramsey]

The DROP IF EXISTS section at the back of the install script is too noisy for new users, they interpret it as failure. Better to figure out a different way to insinuate that code into the upgrade scripts, and leave it out of the install script.

[Mike Taves]

How about adding to the top of the noisy section:

set client_min_messages to warning;

This will ideally show only warnings and errors, but not inferior messages to that level.

[pramsey]

That sounds ideal. How far backward compatible is it in PgSQL?

[Mike Taves]

Looks like it was introduced in 7.3: ​http://www.postgresql.org/docs/7.3/static/runtime-config.html (it is absent in <=7.2)

[pramsey]

Great! Patched in 1.5 (r5385) and trunk (r5386) using the "set client_min_messages to warning" approach.