[postgis-users] postgis_full_version error

2014-10-09 Thread 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

Re: [postgis-users] PostGIS supported by which ArcGIS

2014-10-09 Thread Birgit Laggner
Hi David, I have no experiences with ArcSDE, but I can say, that no dba had to esrify our database in order to enable the interoperability between ArcGIS and PostgreSQL/PostGIS. We have a simple PostgreSQL-DB (version 9.1) with an PostGIS extension (version 2.1). All we had to do was download

Re: [postgis-users] PostGIS supported by which ArcGIS

2014-10-09 Thread Paolo Importuni
Hi, last year, I had the same kind of experience that david described in a previous post. I "esrified" my pg database into an esri enterprise geodatabase, turned db_tune parameter into PG_Geometry and was able to read and write on my table. I can't remember all details but editing of non-spatial

Re: [postgis-users] postgis_full_version error

2014-10-09 Thread Paragon Corporation
Ben, That function hasn't existed for a while in PostGIS. I would say circa 1.3. I think it was a time when we were experimenting with using Java and JTS natively in PostGIS. I suspect you have a mix of PostGIS installs. Did you install a backup from somewhere? If so, you might be able to fix

Re: [postgis-users] postgis_full_version error

2014-10-09 Thread Ben Madin
G'day Regina, You have nailed it, it was a database from an old (postgis 1.5) system - so I actually expected to have many more errors. Luckily it was so old that I had installed postgis into its own schema, so a simple DROP SCHEMA gis CASCADE; has solved this problem. I have 'noticed' this since

Re: [postgis-users] postgis_full_version error

2014-10-09 Thread Paragon Corporation
Ben, I used to see that error a while ago, but don't see it in newer installs even if I don't have topology installed. What does your Select postgis_full_version(); Return now? Thanks, Regina -Original Message- G'day Regina, You have nailed it, it was a database from an old (po