[postgis-devel] Issue 47 in postgis: Avoiding notices upon import of lwpostgis.sql

[codesite-noreply at google.com]

Issue 47: Avoiding notices upon import of lwpostgis.sql
http://code.google.com/p/postgis/issues/detail?id=47

New issue report by dane.springmeyer:
Whenever a user imports lwpostgis.sql into a postgres database the STDOUT  
in the shell gives a large amount of NOTICE's.

I think it would be desirable to make the necessary changes within the  
lwpostgis.sql creation to avoid these notices, for two
reasons

1) New users may not understand that NOTICES are not errors and be  
concerned that their installation did not work

2) When actually Warnings or Errors do occur they are usually spit out  
along with the NOTICES and makes reading through the
output and understanding the error more difficult for new users.

Now, perhaps these notices are not only harmless but either necessary or  
unavoidable.

In this case, I propose adding 'set client_min_messages = 'warning';' to  
the top of the script to manually suppress the NOTICES.

If this is undesirable for some reason, that's fine, just please close the  
issue with an explanation of how they are needed.

I see these notices on SVN trunk with Ubuntu 8.04 and Mac 10.5.

Here is the output I get on Ubuntu 8.04 with Postgis SVN HEAD:
{{{

psql:/usr/share/lwpostgis.sql:44: NOTICE:  type "histogram2d" is not yet  
defined
DETAIL:  Creating a shell type definition.
psql:/usr/share/lwpostgis.sql:50: NOTICE:  return type histogram2d is only  
a shell
psql:/usr/share/lwpostgis.sql:56: NOTICE:  argument type histogram2d is  
only a shell
psql:/usr/share/lwpostgis.sql:62: NOTICE:  argument type histogram2d is  
only a shell
psql:/usr/share/lwpostgis.sql:88: NOTICE:  type "spheroid" is not yet  
defined
DETAIL:  Creating a shell type definition.
psql:/usr/share/lwpostgis.sql:94: NOTICE:  return type spheroid is only a  
shell
psql:/usr/share/lwpostgis.sql:100: NOTICE:  argument type spheroid is only  
a shell
psql:/usr/share/lwpostgis.sql:106: NOTICE:  argument type spheroid is only  
a shell
psql:/usr/share/lwpostgis.sql:131: NOTICE:  type "geometry" is not yet  
defined
DETAIL:  Creating a shell type definition.
psql:/usr/share/lwpostgis.sql:137: NOTICE:  return type geometry is only a  
shell
psql:/usr/share/lwpostgis.sql:143: NOTICE:  argument type geometry is only  
a shell
psql:/usr/share/lwpostgis.sql:149: NOTICE:  argument type geometry is only  
a shell
psql:/usr/share/lwpostgis.sql:170: NOTICE:  return type geometry is only a  
shell
psql:/usr/share/lwpostgis.sql:176: NOTICE:  return type geometry is only a  
shell
psql:/usr/share/lwpostgis.sql:182: NOTICE:  argument type geometry is only  
a shell
psql:/usr/share/lwpostgis.sql:188: NOTICE:  argument type geometry is only  
a shell
psql:/usr/share/lwpostgis.sql:382: NOTICE:  type "box3d" is not yet defined
DETAIL:  Creating a shell type definition.
psql:/usr/share/lwpostgis.sql:388: NOTICE:  argument type box3d is only a  
shell
psql:/usr/share/lwpostgis.sql:394: NOTICE:  return type box3d is only a  
shell
psql:/usr/share/lwpostgis.sql:400: NOTICE:  argument type box3d is only a  
shell
psql:/usr/share/lwpostgis.sql:497: NOTICE:  type "chip" is not yet defined
DETAIL:  Creating a shell type definition.
psql:/usr/share/lwpostgis.sql:503: NOTICE:  return type chip is only a shell
psql:/usr/share/lwpostgis.sql:509: NOTICE:  argument type chip is only a  
shell
psql:/usr/share/lwpostgis.sql:515: NOTICE:  argument type chip is only a  
shell
psql:/usr/share/lwpostgis.sql:542: NOTICE:  type "box2d" is not yet defined
DETAIL:  Creating a shell type definition.
psql:/usr/share/lwpostgis.sql:548: NOTICE:  return type box2d is only a  
shell
psql:/usr/share/lwpostgis.sql:554: NOTICE:  argument type box2d is only a  
shell
psql:/usr/share/lwpostgis.sql:560: NOTICE:  argument type box2d is only a  
shell
}}}


Issue attributes:
	Status: New
	Owner: ----
	Labels: Type-Defect Priority-Medium

-- 
You received this message because you are listed in the owner
or CC fields of this issue, or because you starred this issue.
You may adjust your issue notification preferences at:
http://code.google.com/hosting/settings