On Mon, Jul 22, 2013 at 10:44:52PM +0200, Dechaux Eric CEN (BCQ STIG) wrote:
> However, the make check fails with two kind of errors during the regress
> tests :
>
> PostgreSQL 9.2.4 on i386-pc-solaris2.10, compiled by gcc (GCC) 3.4.3
> (csl-sol210-3_4-branch+sol_rpath), 64-bit
> Postgis 2.0.
Hi,
I need to install PostGIS on a Solaris 10 X64 powered system.
I have successfully built and installed a 32 bits version by I am stuck on the
64 bits build.
The configure part goes without trouble :
PostGIS is now configured for i386-pc-solaris2.10
-- Compiler Info -
I had change the query since yesterday. See below.
It is now taking 115ms, which is quite slow.
I'm now ordering by ST_Distance_Sphere instead of ST_Distance.
WITH knn_query AS
(
SELECT
*
FROM places
WHERE "places"."place_category_id" = 10
ORDER by geom <#> 'SRID=4326;POINT(-79.3937393 43.65
There shouldn't be any issues between PostgreSQL 9.2 and PostGIS 2.0. If
there are, they'd be Fedora derived problems...
-bborie
On Mon, Jul 22, 2013 at 11:48 AM, Max Pyziur wrote:
>
> Greetings,
>
>
> With the release of Fedora 18 there were interoperability issues with
> PostGIS and Postgres
Greetings,
With the release of Fedora 18 there were interoperability issues with
PostGIS and Postgresql. Fedora 18 was released with PostgreSQL 9.2.x and PostGIS
1.5.x. Given the mutual release schedule, only releases of PostGIS 2.0.x and
higher can work with PostgreSQL 9.2.x.
I see that F
On Mon, Jul 22, 2013 at 05:10:22PM +0200, Andreas Neumann wrote:
> Hi,
>
> I have a table with polygons and a table with shared boundaries. My goal
> is to detect the left and right polygons and attach joined left and
> righty polygon type to the LINESTRINGS of the shared boundaries. I want
> to l
Hi,
I have a table with polygons and a table with shared boundaries. My goal
is to detect the left and right polygons and attach joined left and
righty polygon type to the LINESTRINGS of the shared boundaries. I want
to later label these linestrings.
Here is my query:
SELECT lin.gid, lin.the_geo
On Tue, Jul 23, 2013 at 2:17 AM, Ilia wrote:
> Thanks David for your feedback. I got it down to 4ms or so. Below is the
> explain analyze. It's 2 subqueries now. Any ideas for simplification of the
> query?
>
> explain analyze WITH knn_query AS
> (
> SELECT
> *
> FROM places
> WHERE "places".
Thanks David for your feedback. I got it down to 4ms or so. Below is the
explain analyze. It's 2 subqueries now. Any ideas for simplification of the
query?
explain analyze WITH knn_query AS
(
SELECT
*
FROM places
WHERE "places"."place_category_id" = 10
ORDER by geom <#> 'SRID=4326;POINT(-79.3
