[postgis-users] Still installation (last step) problems

[Bato Pure]

Hi, 

Thanks Techer Jean David, strk and Darren H.

Current situation after giving "psql -d mydb -f
postgis.sql":

BEGIN
        message
------------------------
 PL/PgSQL is installed.
(1 row)
 
psql:postgis.sql:38: NOTICE:  type "histogram2d" is
not yet defined
DETAIL:  Creating a shell type definition.
CREATE FUNCTION
psql:postgis.sql:43: NOTICE:  argument type
histogram2d is only a shell
CREATE FUNCTION
CREATE TYPE
psql:postgis.sql:59: NOTICE:  type "box3d" is not yet
defined
DETAIL:  Creating a shell type definition.
CREATE FUNCTION
psql:postgis.sql:64: NOTICE:  argument type box3d is
only a shell
CREATE FUNCTION
CREATE TYPE
psql:postgis.sql:79: NOTICE:  type "spheroid" is not
yet defined
DETAIL:  Creating a shell type definition.
CREATE FUNCTION
psql:postgis.sql:84: NOTICE:  argument type spheroid
is only a shell
CREATE FUNCTION
CREATE TYPE
psql:postgis.sql:99: NOTICE:  type "wkb" is not yet
defined
DETAIL:  Creating a shell type definition.
CREATE FUNCTION
psql:postgis.sql:104: NOTICE:  argument type wkb is
only a shell
CREATE FUNCTION
psql:postgis.sql:109: NOTICE:  return type wkb is only
a shell
CREATE FUNCTION
psql:postgis.sql:118: NOTICE:  type "chip" is not yet
defined
DETAIL:  Creating a shell type definition.
CREATE FUNCTION
psql:postgis.sql:123: NOTICE:  argument type chip is
only a shell
CREATE FUNCTION
CREATE TYPE
psql:postgis.sql:139: NOTICE:  type "geometry" is not
yet defined
DETAIL:  Creating a shell type definition.
CREATE FUNCTION
psql:postgis.sql:144: NOTICE:  argument type geometry
is only a shell
CREATE FUNCTION
CREATE TYPE
CREATE FUNCTION
psql:postgis.sql:179: NOTICE:  CREATE TABLE / PRIMARY
KEY will create implicit index "spatial_ref_sys_pkey"
for table "spatial_ref_sys"
CREATE TABLE
psql:postgis.sql:201: NOTICE:  CREATE TABLE / PRIMARY
KEY will create implicit index "geometry_columns_pk"
for table "geometry_columns"
CREATE TABLE
UPDATE 1

...(few lines without errors)

psql:postgis.sql:444: NOTICE:  return type wkb is only
a shell
CREATE FUNCTION
psql:postgis.sql:449: NOTICE:  return type wkb is only
a shell
CREATE FUNCTION
psql:postgis.sql:454: NOTICE:  argument type wkb is
only a shell
CREATE FUNCTION
... (repeating the line)

... (few lines without errors)
CREATE FUNCTION
COMMIT
______________________________________________________

What I did is:

- reinstalled proj4 with its default location
- reinstalled postgis
- dropped mydb and recreated it
- /usr/local/lib was added to /etc/ld.so.conf as
before

OS: Redhat 9
Postgres: 7.4.3

Any more help?

Bato


	
		
__________________________________
Do you Yahoo!?
Vote for the stars of Yahoo!'s next ad campaign!
http://advision.webevents.yahoo.com/yahoo/votelifeengine/