[postgis-users] collect(geom) in rc3?
strk at refractions.net
strk at refractions.net
Fri Mar 4 01:02:08 PST 2005
Mike, I confirm accum() works for me on linux:
strk=# select accum(the_geom) from twopoints;
accum
---------------------------------------------------------------------------------------------------------
{01010000206B7F0000C17B60EB0BCD2D412F0A8C13E7FE5441:01010000206B7F000064193B2FBDD72D413A1E14BB32FD5441}
(1 row)
strk=# select astext(collect(the_geom)) from twopoints;
astext
---------------------------------------------------------------------------------
MULTIPOINT(976517.959720485 5503900.30542235,977886.592247766 5502154.92310291)
(1 row)
I don't have (and don't wont to have ;) any access to win32.
Mark, can you reproduce the bug ?
--strk;
On Fri, Mar 04, 2005 at 03:34:06AM -0500, Mike Leahy wrote:
> Ok, here's a sample table with two of the points from my table (does it matter
> if the geometry column is not in the geometry_columns table for these tests?):
>
> CREATE TABLE twopoints (
> the_geom geometry
> );
> COPY twopoints (the_geom) FROM stdin;
> 01010000206B7F0000C17B60EB0BCD2D412F0A8C13E7FE5441
> 01010000206B7F000064193B2FBDD72D413A1E14BB32FD5441
> \.
>
> I tried collect(), and got the same crash. I don't find a function called
> GeomAccum() - is this the same as Accum()? Either way, Accum() crashes the same
> as collect().
>
> I tried array_append, as you suggest, and it works fine:
>
> testdb=# select array_append(ARRAY[1,2], 3) as artest;
> artest
> ---------
> {1,2,3}
> (1 row)
>
> Any other suggestions?
>
> Mike
>
>
>
> Quoting strk at refractions.net:
>
> > Mike, I tried some collect() on different input and had no
> > problems. force_collection() didn't change collect().
> > You upgrade procedure is correct.
> >
> > Can you use GeomAccum() or does it segfault as well ?
> > Can you use other array-based pgsql function ? (array_append - for example).
> > Can you reproduce the bug with a simple 2-small-records table ? Would
> > you send it here if you can ?
> >
> > --strk;
> >
> > On Thu, Mar 03, 2005 at 05:58:26PM -0500, Mike Leahy wrote:
> > > Hey all,
> > >
> > > I think maybe my message (below) was overlooked because I forgot to
> > > change the subject. Does anyone else have the same problem I've got
> > > with using the collect() function? Is it just a Win32 problem, or maybe
> > > even just my own isolated problem? Maybe someone else with RC3 can give
> > > the collect() function a try...
> > >
> > > Thanks,
> > > Mike
> > >
> > >
> > > Mike Leahy wrote:
> > >
> > > >Hey folks,
> > > >
> > > >I'm going to suggest that RC3 is not ready...I just tried out the Mark's
> > > >installer and ran into trouble. There are still issues with MapServer
> > > >connectivity, which are effectively the opposite of the problem that I had
> > with
> > > >RC2. To get a mapserver to draw a layer from a postgis points table using
> > RC2,
> > > >I had to use the following DATA string:
> > > >
> > > >DATA "the_geom from (select oid, place_id, entry, name, collect(the_geom)
> > as
> > > >the_geom from gis_culturepoints group by oid, place_id, entry, name) as
> > foo
> > > >using srid=32619 using uniqe oid"
> > > >
> > > >It's not ideal, but I guess that the 'collect(the_geom)' solved a problem
> > with
> > > >force_collection() not working, am I right? At any rate, after installing
> > RC3
> > > >(with PostgreSQL 8.0.1/WinXP, etc), the same DATA string causes postgres
> > to crash.
> > > >
> > > >I changed the DATA string for the layer back to what it normally would be,
> > and
> > > >had no problems with mapserver:
> > > >
> > > >DATA "the_geom from gis_culturepoints using srid=32619 using uniqe oid"
> > > >
> > > >Just to be sure, I tried the collect() function in psql from a command
> > window,
> > > >and it crashed as well, so I think this is a more significant bug than
> > just
> > > >MapServer connectivity:
> > > >
> > > >testdb=# select collect(the_geom) from gis_culturepoints;
> > > >server closed the connection unexpectedly
> > > > This probably means the server terminated abnormally
> > > > before or while processing the request.
> > > >The connection to the server was lost. Attempting reset: Failed.
> > > >
> > > >
> > > >So...my first guess is that perhaps whatever fix solved the
> > force_collection()
> > > >problem also broke the collect() function, though maybe something else
> > > >altogether has happened.
> > > >
> > > >FYI: When I uninstalled RC2, I verified that that the postgis-related dlls
> > and
> > > >sql files (that I know of) were successfully removed. I backed-up all
> > > >non-spatial tables, and dropped my database. After installing RC3, I
> > recreated
> > > >my database, reloaded the spatial table from scripts previously generated
> > by
> > > >shp2pgsql, then reloaded the other non-spatial tables. Is there anything
> > I
> > > >might have missed that could be causing an incompatibility with my
> > current
> > > >PosgreSQL installation and RC3?
> > > >
> > > >Does anyone know of anything else I should mention, or any tests I should
> > perform?
> > > >
> > > >Kind regards,
> > > >Mike
> > > >
> > > >Quoting Mark Cave-Ayland <m.cave-ayland at webbased.co.uk>:
> > > >
> > > >
> > > >
> > > >>>-----Original Message-----
> > > >>>From: postgis-users-bounces at postgis.refractions.net
> > > >>>[mailto:postgis-users-bounces at postgis.refractions.net] On
> > > >>>Behalf Of Markus Schaber
> > > >>>Sent: 03 March 2005 11:14
> > > >>>To: PostGIS Users Discussion
> > > >>>Subject: Re: [postgis-users] Ready for 1.0.0 ?
> > > >>>
> > > >>>
> > > >>(cut)
> > > >>
> > > >>
> > > >>
> > > >>>Do you think an RC4 would be the correct solution to make the
> > > >>>people test the latest fixes? Strk could then release 1.0.0
> > > >>>unchanged if RC4 is fine.
> > > >>>
> > > >>>
> > > >>Yes, I think especially as strk has fixed one crashing bug since then.
> > I'm
> > > >>just not convinced that RC3 has been out long enough for people to test
> > to
> > > >>make sure that the Mapserver connector issues have been solved etc.
> > > >>
> > > >>
> > > >>
> > > >>>Fine. What is your experience building the jdbc2 stuff on
> > > >>>windows? I'm pretty shure some additional weird problems
> > > >>>might pop up there. You should check out the latest CVS, as
> > > >>>there are some Makefile changes compared to RC3 that may ease
> > > >>>building in your environment.
> > > >>>
> > > >>>
> > > >>The only change I've had to make so far is to change RUNCP and BUILDCP
> > to
> > > >>use semi-colons instead of colons - otherwise the building under Windows
> > > >>fails. I don't know if it's possible to build some of this functionality
> > > >>into the Makefile or to just simply make a note of it in the comments
> > > >>somewhere.
> > > >>
> > > >>Another thing: I've compiled the JARs as standard using a 1.4 JDK.
> > However
> > > >>the notes on jdbc.postgresql.org aren't particularly clear as to which
> > > >>versions to use. In particular, it notes that JDBC1 is obsolete with
> > > >>PostgreSQL 8.0. What do you think would be the best way to compile the
> > jdbc2
> > > >>driver? I'm thinking of compiling with a -target 1.3 option, and
> > including
> > > >>the resulting standard/debug JARs in the Win32 installer?
> > > >>
> > > >>
> > > >>
> > > >>>I think we should make as much testing as possible.
> > > >>>
> > > >>>
> > > >>Agreed. I must admit I haven't looked at the regression tests in a long
> > time
> > > >>to see what coverage they give us, but I'm hoping that passing the
> > > >>regression tests should be a good enough indication that PostGIS works on
> > a
> > > >>particular platform.
> > > >>
> > > >>
> > > >>Kind regards,
> > > >>
> > > >>Mark.
> > > >>
> > > >>------------------------
> > > >>WebBased Ltd
> > > >>South West Technology Centre
> > > >>Tamar Science Park
> > > >>Plymouth
> > > >>PL6 8BT
> > > >>
> > > >>T: +44 (0)1752 791021
> > > >>F: +44 (0)1752 791023
> > > >>W: http://www.webbased.co.uk
> > > >>
> > > >>
> > > >>_______________________________________________
> > > >>postgis-users mailing list
> > > >>postgis-users at postgis.refractions.net
> > > >>http://postgis.refractions.net/mailman/listinfo/postgis-users
> > > >>
> > > >>
> > > >>
> > > >
> > > >
> > > >
> > > >
> > > >----------------------------------------
> > > >This mail sent through www.mywaterloo.ca
> > > >_______________________________________________
> > > >postgis-users mailing list
> > > >postgis-users at postgis.refractions.net
> > > >http://postgis.refractions.net/mailman/listinfo/postgis-users
> > > >
> > > >
> > > >
> > >
> >
> > > _______________________________________________
> > > postgis-users mailing list
> > > postgis-users at postgis.refractions.net
> > > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
>
>
>
>
> ----------------------------------------
> This mail sent through www.mywaterloo.ca
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
More information about the postgis-users
mailing list