[postgis-users] postgis init script fails at end

[Perazim]

thanks

On Tue, 2010-01-19 at 11:09 +0100, Suhr, Ralf wrote:
> 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
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users