[postgis-users] postgis_full_version error

[Ben Madin]

G'day all,

I'm not sure if this is a postgis or an ubuntu issue, but having just
installed postgis on to ubuntu 14.04 from the pgdg repository, I am getting
this error :

  # select postgis_full_version();
  ERROR:  function postgis_jts_version() does not exist
  LINE 1: SELECT postgis_jts_version()
                 ^
  HINT:  No function matches the given name and argument types. You might
need to add explicit type casts.
  QUERY:  SELECT postgis_jts_version()
  CONTEXT:  PL/pgSQL function postgis_full_version() line 15 at SQL
statement


I have previously installed onto many Ubuntu 12.04 without this problem. I
guess there are two parts:

1. do I have / need jts (it is showing geos 3.4.2-CAPI-1.8.2 r3921) ?

2. if I don't have it, should it fail completely, or just return NULL ?

cheers

Ben




-- 

Ben Madin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20141009/f559fddd/attachment.html>