[postgis-devel] trunk regress fails

Kevin Neufeld kneufeld at refractions.net
Wed Jul 22 11:13:05 PDT 2009


I don't think this is related to the path problem, but this also happens on the same box.
This is error I get when trying to install postgis in a new install of 8.2.13

postgis=# \i /var/home/buildbot/opt/pgsql/8.2/share/contrib/postgis.sql
...
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
psql:/var/home/buildbot/opt/pgsql/8.2/share/contrib/postgis.sql:3871: ERROR:  cannot cast type text to cstring
LINE 4:   CAST('quad_segs='||CAST($3 AS text) as cstring))
                                                  ^
psql:/var/home/buildbot/opt/pgsql/8.2/share/contrib/postgis.sql:3881: ERROR:  current transaction is aborted, commands 
ignored until end of transaction block
psql:/var/home/buildbot/opt/pgsql/8.2/share/contrib/postgis.sql:3887: ERROR:  current transaction is aborted, commands 
ignored until end of transaction block

-- Kevin

Kevin Neufeld wrote:
> Does anyone have insight to what is happening here?
> 
> Trunk builds and installs just fine.  But when I try to run the 
> regression tests, make fails.
> 
> # after make install
> cd regress
> make
> sed 
> 's,$libdir/postgis,/var/home/buildbot/workspace/src/regress/../postgis/libpostgis,g' 
> ../postgis/postgis.sql > postgis.sql
> ./run_test: line 388: psql: command not found
> Creating spatial db postgis_reg
> ./run_test: line 395: createdb: command not found
> ./run_test: line 396: createlang: command not found
> ./run_test: line 415: psql: command not found
> 
>  Something went wrong (no postgis installed in postgis_reg).
>  For details, check 
> /var/home/buildbot/workspace/regress_results/regress_log
> 
> 
> But, psql IS on the PATH:
> [buildbot at falcon regress]$ echo $PATH
> /usr/local/bin:/bin:/usr/bin:/var/home/buildbot/opt/pgsql/8.2/bin
> 
> [buildbot at falcon regress]$ which psql
> ~/opt/pgsql/8.2/bin/psql
> 
> [buildbot at falcon regress]$ psql -l
>         List of databases
>    Name    |  Owner   | Encoding
> -----------+----------+----------
>  postgres  | buildbot | UTF8
>  template0 | buildbot | UTF8
>  template1 | buildbot | UTF8
> (3 rows)
> 
> 
> Cheers,
> Kevin
> 
> 
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-devel



More information about the postgis-devel mailing list