Opened 10 years ago

Closed 10 years ago

#415 closed defect (fixed)

postgis.sql install script is noisy with NOTICES

Reported by: pramsey Owned by: pramsey
Priority: medium Milestone: PostGIS 1.5.1
Component: postgis Version: 1.5.X
Keywords: Cc:

Description

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.

Change History (4)

comment:1 Changed 10 years ago by 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.

comment:2 Changed 10 years ago by pramsey

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

comment:3 Changed 10 years ago by 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)

comment:4 Changed 10 years ago by pramsey

Resolution: fixed
Status: newclosed

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

Note: See TracTickets for help on using tickets.