Possibly a permissions problem? I just ran the tests on my new
Leopard build, using GEOS 3, and got 36/37 fails.
Look in that /var/folders/... loader.err. I got:
BEGIN
psql:/var/folders/sR/[snip]/-Tmp-/loader:2: NOTICE: CREATE TABLE will
create implicit sequence "loadedshp_gid_seq" for serial column
"loadedshp.gid"
psql:/var/folders/sR/[snip]/-Tmp-/loader:2: NOTICE: CREATE TABLE /
PRIMARY KEY will create implicit index "loadedshp_pkey" for table
"loadedshp"
CREATE TABLE
psql:/var/folders/sR/[snip]/-Tmp-/loader:3: ERROR: permission denied
for relation geometry_columns
CONTEXT: SQL statement "DELETE FROM geometry_columns WHERE
f_table_catalog = '' AND f_table_schema = 'public' AND f_table_name
= 'loadedshp' AND f_geometry_column = 'the_geom'"
PL/pgSQL function "addgeometrycolumn" line 94 at execute statement
SQL statement "SELECT AddGeometryColumn('', $1 , $2 , $3 , $4 , $5 ,
$6 )"
PL/pgSQL function "addgeometrycolumn" line 4 at SQL statement
Even though I made my user role the owner of the postgis_reg database,
the lwpostgis.sql must be run as th postgres role, and it gets
ownership of the geometry_columns table. And one big annoyance I've
had with postgres is that it doesn't inherit privileges like you'd
think.
After setting up the postgis_reg DB for postgis, grant yourself all
privileges on the geometry_columns table. After doing this, I now get
32/37 fails - still a lot, but it's a start.
On Nov 25, 2007, at 1:22 PM, John Cartwright wrote:
Hello All,
Trying to compile v1.3.1 on leopard. Compilation seems to go OK,
but 35 out of 37 tests fail on the "make check" prior to
installation. For example:
loader/Point. failed (running shp2pgsql: /var/folders/v1/
v1z9PHeJEvGQIvBCSUU0QE+++TI/-Tmp-//loader.err)
loader.err contains:
../loader/shp2pgsql: shape (.shp) or index files (.shx) can not be
opened.
The configuration summary is listed below. Any ideas on what I'm
doing wrong here?
Thanks!
--john
Config Summary:
HOST_OS: darwin9.1.0
PGSQL: /usr/local/pgsql/bin/pg_config
GEOS: /usr/local/geos-2.2.3/bin/geos-config (with C-API)
(ldflags: -L/usr/local/geos-2.2.3/lib)
PROJ: prefix=/usr/local/proj-4.5.0 libdir=/usr/local/proj-4.5.0/lib
ICONV: 1 -liconv
PORTNAME: darwin
PREFIX: /usr/local/postgis-1.3.1
EPREFIX: ${prefix}
DOC: ${prefix}/share/doc
DATA: ${datarootdir}
MAN: ${datarootdir}/man
BIN: ${exec_prefix}/bin
EXT: ${exec_prefix}/lib (${exec_prefix}/lib)
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
-----
William Kyngesburye <kyngchaos*at*kyngchaos*dot*com>
http://www.kyngchaos.com/
"We are at war with them. Neither in hatred nor revenge and with no
particular pleasure I shall kill every ___ I can until the war is
over. That is my duty."
"Don't you even hate 'em?"
"What good would it do if I did? If all the many millions of people of
the allied nations devoted an entire year exclusively to hating the
____ it wouldn't kill one ___ nor shorten the war one day."
<Ha, ha> "And it might give 'em all stomach ulcers."
- Tarzan, on war
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
