[postgis-users] error executing psql -d mydb -f postgis.sql

root porfidia at anpa.it
Thu Aug 1 08:04:38 PDT 2002


Hi all
I'm newby of the list and postgis too
I installed Postgis on postgresql 7.2.1 (default installation from
tarball) and Red Hat7.2 and all worked fine till the command psql.......

It gives me this error
I took postgis.sql file from
/usr/local/pgsql/share/contrib/postgis.sql   and
in /usr/local/pgsql/bin I made ./psql -d mydb -f
/usr/local/share/contrib/postgis.sql  as postgres user
BEGIN
psql:/usr/local/pgsql/share/contrib/postgis.sql:772: ERROR:  argument
type geometry does not exist
psql:/usr/local/pgsql/share/contrib/postgis.sql:775: NOTICE:  current
transaction is aborted, queries ignored until end of transaction block
*ABORT STATE*
.
.
.
.
and  at the end
psql:/usr/local/pgsql/share/contrib/postgis.sql:1026: NOTICE:  current
transaction is aborted, queries ignored until end of transaction block
*ABORT STATE*
COMMIT
thus I checked all permissions and  chown to postgres user
I tried 0.7.1 dist and cvs snapshot dist but nothing change
Anybody can help me
Am i wrong
Am I right
oohh my god what have I done?





More information about the postgis-users mailing list