[postgis-devel] Issue 47 in postgis: Avoiding notices upon import of lwpostgis.sql
codesite-noreply at google.com
codesite-noreply at google.com
Wed Aug 20 10:52:58 PDT 2008
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
More information about the postgis-devel
mailing list