[postgis-users] postgis init script fails at end

Suhr, Ralf Ralf.Suhr at itc-halle.de
Tue Jan 19 02:09:37 PST 2010 

This are Notices. The last message is COMMIT. Postgis.sql wan't be commited if there are any errors.

Gr Ralf


-----Ursprüngliche Nachricht-----
Von: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] Im Auftrag von Perazim
Gesendet: Dienstag, 19. Januar 2010 10:57
An: PostGIS Users Discussion
Betreff: Re: [postgis-users] postgis init script fails at end

On Tue, 2010-01-19 at 10:50 +0100, Suhr, Ralf wrote:
> I can't see any errors.
> 
> Gr Ralf
> 
What are these?

CREATE FUNCTION
psql:/usr/share/pgsql/contrib/postgis.sql:6942: NOTICE:  function
asgml(geometry,pg_catalog.int4,pg_catalog.int4) does not exist, skipping
DROP FUNCTION
psql:/usr/share/pgsql/contrib/postgis.sql:6943: NOTICE:  function
asukml(geometry,pg_catalog.int4,pg_catalog.int4) does not exist,
skipping
DROP FUNCTION
psql:/usr/share/pgsql/contrib/postgis.sql:6944: NOTICE:  function
asukml(geometry,pg_catalog.int4) does not exist, skipping
DROP FUNCTION
psql:/usr/share/pgsql/contrib/postgis.sql:6945: NOTICE:  function
asukml(geometry) does not exist, skipping
DROP FUNCTION
psql:/usr/share/pgsql/contrib/postgis.sql:6946: NOTICE:  function
create_histogram2d(box2d,pg_catalog.int4) does not exist, skipping
DROP FUNCTION
DROP FUNCTION
psql:/usr/share/pgsql/contrib/postgis.sql:6948: NOTICE:  function
jtsnoop(geometry) does not exist, skipping
DROP FUNCTION
psql:/usr/share/pgsql/contrib/postgis.sql:6949: NOTICE:  function
postgis_jts_version() does not exist, skipping
DROP FUNCTION
psql:/usr/share/pgsql/contrib/postgis.sql:6950: NOTICE:  function
st_pointn(geometry) does not exist, skipping
DROP FUNCTION
psql:/usr/share/pgsql/contrib/postgis.sql:6951: NOTICE:  function
st_create_histogram2d(box2d,pg_catalog.int4) does not exist, skipping
DROP FUNCTION
COMMIT
[yossi at maps ~]$ 




> -----Ursprüngliche Nachricht-----
> Von: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] Im Auftrag von Perazim
> Gesendet: Dienstag, 19. Januar 2010 10:12
> An: postgis-users at postgis.refractions.net
> Betreff: [postgis-users] postgis init script fails at end
> 
> Running postgis-1.4.1-3.fc12.i686 and postgresql-8.4.2-1.fc12.i686 from
> rpms on fedora 12. I am setting up to run the openstreetmap server. When
> I ran the posgis init script, postgis.sql, I received the following
> output. I suspect that there have been some recent updates that may have
> broken my system as I tried this a month ago and it worked then. Thanks
> in advance.This is the last part of the output with the errors at the
> end:
> 
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE TYPE
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE AGGREGATE
> CREATE AGGREGATE
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE AGGREGATE
> CREATE AGGREGATE
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> psql:/usr/share/pgsql/contrib/postgis.sql:2243: NOTICE:  CREATE TABLE /
> PRIMARY KEY will create implicit index "spatial_ref_sys_pkey" for table
> "spatial_ref_sys"
> CREATE TABLE
> psql:/usr/share/pgsql/contrib/postgis.sql:2261: NOTICE:  CREATE TABLE /
> PRIMARY KEY will create implicit index "geometry_columns_pk" for table
> "geometry_columns"
> CREATE TABLE
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE CAST
> CREATE CAST
> CREATE CAST
> CREATE CAST
> CREATE CAST
> CREATE CAST
> CREATE CAST
> CREATE CAST
> CREATE CAST
> CREATE CAST
> CREATE CAST
> CREATE CAST
> CREATE CAST
> CREATE CAST
> CREATE CAST
> CREATE CAST
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE AGGREGATE
> CREATE AGGREGATE
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE AGGREGATE
> CREATE AGGREGATE
> psql:/usr/share/pgsql/contrib/postgis.sql:4085: NOTICE:  type "pgis_abs"
> is not yet defined
> DETAIL:  Creating a shell type definition.
> CREATE FUNCTION
> psql:/usr/share/pgsql/contrib/postgis.sql:4090: NOTICE:  argument type
> pgis_abs is only a shell
> CREATE FUNCTION
> CREATE TYPE
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE AGGREGATE
> CREATE AGGREGATE
> CREATE AGGREGATE
> CREATE AGGREGATE
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE AGGREGATE
> CREATE AGGREGATE
> CREATE AGGREGATE
> CREATE AGGREGATE
> CREATE AGGREGATE
> CREATE AGGREGATE
> CREATE AGGREGATE
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> CREATE FUNCTION
> psql:/usr/share/pgsql/contrib/postgis.sql:6942: NOTICE:  function
> asgml(geometry,pg_catalog.int4,pg_catalog.int4) does not exist, skipping
> DROP FUNCTION
> psql:/usr/share/pgsql/contrib/postgis.sql:6943: NOTICE:  function
> asukml(geometry,pg_catalog.int4,pg_catalog.int4) does not exist,
> skipping
> DROP FUNCTION
> psql:/usr/share/pgsql/contrib/postgis.sql:6944: NOTICE:  function
> asukml(geometry,pg_catalog.int4) does not exist, skipping
> DROP FUNCTION
> psql:/usr/share/pgsql/contrib/postgis.sql:6945: NOTICE:  function
> asukml(geometry) does not exist, skipping
> DROP FUNCTION
> psql:/usr/share/pgsql/contrib/postgis.sql:6946: NOTICE:  function
> create_histogram2d(box2d,pg_catalog.int4) does not exist, skipping
> DROP FUNCTION
> DROP FUNCTION
> psql:/usr/share/pgsql/contrib/postgis.sql:6948: NOTICE:  function
> jtsnoop(geometry) does not exist, skipping
> DROP FUNCTION
> psql:/usr/share/pgsql/contrib/postgis.sql:6949: NOTICE:  function
> postgis_jts_version() does not exist, skipping
> DROP FUNCTION
> psql:/usr/share/pgsql/contrib/postgis.sql:6950: NOTICE:  function
> st_pointn(geometry) does not exist, skipping
> DROP FUNCTION
> psql:/usr/share/pgsql/contrib/postgis.sql:6951: NOTICE:  function
> st_create_histogram2d(box2d,pg_catalog.int4) does not exist, skipping
> DROP FUNCTION
> COMMIT
> [yossi at maps ~]$ 
> 
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users


_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

More information about the postgis-users mailing list