From: jomarlla at cgf.upv.es (=?windows-1252?Q?Jos=E9_Carlos_Mart=EDnez_Llario?=) Date: Wed, 11 Feb 2015 10:23:03 +0100 Subject: [Pljava-dev] pljava and postgis 2.0 postgresql 9.1 In-Reply-To: <4F8C0D67.6020304@cgf.upv.es> References: <4F0B3591.4040703@cgf.upv.es> <4F21AC31.8070600@cgf.upv.es> <4F23E6FF.60706@cgf.upv.es> <4F8C07F8.4010809@cgf.upv.es> <4F8C0D67.6020304@cgf.upv.es> Message-ID: <54DB1F77.1020800@cgf.upv.es> Hi list, long time without knowing anything from this list :) Wanted to use pljava with the last versions of postgres in windows and linux. The last update of pljava is 3 years ago (postgres 9.1). What can I do in order to obtain de pljava binaries for postgres 9.2,9.3,9.4 in linux and ms windows 32 and 64 bits? I remember the last time I tried to compile pljava by myself and it was hard and I just could get a dll that worked with a specific version of linux. Cheers, Jose On 16/04/2012 14:15, Jose Carlos Martinez Llario wrote: > What about installing postgis 1.5 in an empty database, is it working? > > On 16/04/2012 14:02, Simon Greener wrote: >> Jose, >> >>> Hi Simon, how are you? >> >> I'm really well. Yourself? >> >>> the template in postgres is a normal database where some sql files has >>> been run. >>> If you already have jaspa installed then you can run into the same >>> database the postgis sql files: postgis.sql, spatial_ref_sys. >> >> I found C:\Program >> Files\PostgreSQL\9.0\share\contrib\postgis-1.5\postgis.sql and ran it in >> the database I created using the jaspa template but I got this: >> >> ERROR: function box3d_out(box3d) does not exist >> >> ********** Error ********** >> >> ERROR: function box3d_out(box3d) does not exist >> SQL state: 42883 >> >> >> See the attached. The schema is "pubic" within the "ss" database >> (created using createdb and the jaspatemplate). >> >>> Regarding to postgres 9.1 and pljava, the problem is the pljava project >>> has not built binaries still for pg 9.1 eventhough the sources are >>> ready >>> for pg9.1 from long time ago. It seems that to build the binaries its >>> kind of troublesome because I dont undesrtand why they dont build them. >>> The previous time I had to say that many times to 'force' the pljava >>> team to build them. >> >> I thought that this was the case as I had looked at the pljava >> project. If it is that far behind it will always provide you with >> problems. Luckily the Oracle JVM is part of the db. >> >> When I get the ST_DelaunayTrianges working in my project I will show >> you what I have done. >> >> regards >> Simon > -- ------------------------------ Jos? Carlos Mart?nez Llario http://cartosig.upv.es Producci?n Cartogr?fica y SIG. Dpto. Ingenier?a Cartogr?fica. Univ. Polit?cnica de Valencia. ------------------------------