[postgis-users] collect(geom) in rc3?
Mike Leahy
mgleahy at fes.uwaterloo.ca
Fri Mar 4 01:28:31 PST 2005
Ok,
Thanks for the help though. I don't think I would have known where to check in
the changes file anyway, had I thought to look there first.
Presumably that fix applies to collect() as well?
Mike
Quoting strk at refractions.net:
> Oops... sorry... I just cheched the CHANGES file:
>
> - segfault fix in geom_accum()
>
> I think we'll soon release an RC4 package... sorry for the confusion.
>
> --strk;
>
> On Fri, Mar 04, 2005 at 10:02:08AM +0100, strk at refractions.net wrote:
> >
> > 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
> > _______________________________________________
> > 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
More information about the postgis-users
mailing list