Regina, I'm copying this to the plr-general list ([EMAIL PROTECTED]).
I can't say that I'm getting the same error. I've installed the version from David's installer, and I did the exact same example from the PL/R docs that you're trying and it's working for me too. Maybe there's an encoding problem in your case? Mike Obe, Regina wrote: > > Unfortunately I'm not in the PL/R newsgroup yet and I don't have Joe's email > address, so can someone pass this message along. I'm updating my instruction > docs accordingly to reflect this issue and still writing up some followup > tutorials. > > When testing creating the median function as described in the docs using > PgAdmin, I would get parse R errors when using it. After some research > (googling - others had the same problem) and refollowing my tracks (since I > was able to get it right a couple of times, but not consistently). I > discovered it was the line breaks in the function that was causing the > problem. > > I had to do this > > create or replace function r_median(_float8) > returns float as 'median(arg1)' language 'plr'; > > > instead of what is mentioned in the docs - this > create or replace function r_median(_float8) returns float as ' > median(arg1) > ' language 'plr'; > > Evidentally R parser chokes when it runs into line breaks. > > Hope that helps, > Regina > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of TECHER David > Sent: Monday, June 18, 2007 6:16 PM > To: [EMAIL PROTECTED]; PostGIS Users Discussion > Subject: Re: [postgis-users] Combined Windows version of PostGIS/P-LR > > Mike Leahy a écrit : >> Hey all, >> >> I'm just wondering if this thread should move back to the plr-general >> list. In particular, I think it would be good if Joe is able to add a >> link to the installer on the PL/R web page. I just tried the installer, >> and it works great - nice work David. >> >> I did notice, however, that it claims to be installing PgRouting in the >> welcome screen, and it appears as PgRouting in the Windows uninstall >> list. > Well I did the installer, last Saturday night and I was hurry. > You know when you haven't slept all a night, you don't see errors > thanks. >> Also, I think more than is needed is being added to the Path >> variable. In my case, this is what gets added after the installer is done: >> >> "\;C:\Program Files\R\R-2.5.0\bin;C:\Program >> Files\PostgreSQL\8.2\bin;C:\Program Files\PostgreSQL\8.2\lib" >> >> > I reduced it to > > \;C:\Program Files\R\R-2.5.0\bin > >> When I had installed PL/R manually, I seemed to be able to get away with >> adding just ";C:\Program Files\R\R-2.5.0\bin". > Yes it is, you're right. But if you use a function like > > select load_r_typenames(); > > pl/r needs to know what it you R_HOME environment variable. >> Also, if I happen to >> re-install PL/R, the entire string above will appear multiple times in >> the Path variable. Is it possible for the installer to check for that? >> >> > I've only been able to detect if R directory is present in PATH variable > for the moment! > Not able to remove it for the moment from a previous install > > If you want, my Inno Setup script is available at > > http://www.davidgis.fr/download/plr-8.2.0.4-win32-src.zip > > If someone is used here to using Inno SetUp, no problem to improve it. > >> Regards, >> Mike >> >> TECHER David wrote: >> >>> Hi Regina, >>> >>> Many thanks for these interesting link! Very excellent! >>> >>> I will wait for the next series of your articles! >>> >>> --david; >>> >>> Obe, Regina a écrit : >>> >>>> Since Dave was doing his part, I figured I would help out the cause a >>>> little. R is pretty new to me too but looks like it could be very useful. >>>> I drafted up a quick getting started and included David's link in there. >>>> http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgresql_plr_tut01 >>>> >>>> Let me know any parts that seem unclear or where I went wrong. The >>>> steps seemed to work for me. >>>> Thanks, >>>> Regina >>>> >>>> ------------------------------------------------------------------------ >>>> *From:* [EMAIL PROTECTED] on behalf of >>>> TECHER David >>>> *Sent:* Sun 6/17/2007 2:53 AM >>>> *To:* PostGIS Users Discussion >>>> *Subject:* Re: [postgis-users] Combined Windows version of PostGIS/P-LR >>>> >>>> Dear Jan, >>>> >>>> I begun to use PL/R. As you know, I'm not a expert in R >>>> >>>> Compiling with PostgreSQL 8.2.4 on win32 ...no problem! >>>> >>>> >>>> These release is available at >>>> >>>> http://www.davidgis.fr/download/plr-8.2.0.4_0_win32.exe >>>> >>>> I've tryed to see here if >>>> >>>> first R 2.5.0 is available on the computer where you want to install it. >>>> >>>> else it stop! >>>> >>>> The installer updates the R_HOME environment variable >>>> and update the PATH in order to adding 'R_HOME'/bin directory >>>> >>>> Let me know if it works for you >>>> >>>> createdb testR >>>> >>>> psql -d testR -f / "path/to/your/postgresql/dir"/share/contrib/plr.sql >>>> >>>> psql testR >>>> >>>> select load_r_modules(); >>>> >>>> select * from plr_environ(); >>>> >>>> and so on >>>> >>>> --david; >>>> >>>> Jan Hartmann a écrit : >>>> >>>>> I agree. A separate installer for PL/R would be the first thing to >>>>> create. Am I right that that would not be very difficult? After that, >>>>> though, I would very much like to have a *combined* version, with PL/R >>>>> and PostGIS both enabled. I am not sure how difficult that would be, >>>>> but, as I said, it would be a marvelous example of Open Source >>>>> software cooperation. The additional packages Mike mentioned don't >>>>> have to be installed prior to installing PL/R; you can install them in >>>>> the regular way in R (R INSTALL), and an existing PostgreSQL database >>>>> with PL/R will recognise them after a restart. >>>>> >>>>> BTW: deldir was a major reason for me to experimnt with a combined >>>>> version: the power of voronoi diagrams in a PostGIS database! >>>>> >>>>> Jan >>>>> >>>>> Mike Leahy wrote: >>>>> >>>>>> David/Jan: >>>>>> >>>>>> Although PostGIS and PL/R can be complimentary tools, I think a >>>>>> >>>> separate >>>> >>>>>> installer (for now at least) would make the most sense for PL/R. At >>>>>> least that way there is still the option for other users to install >>>>>> >>>> PL/R >>>> >>>>>> without PostGIS, and vice-versa. >>>>>> >>>>>> At the same time, however, I can see how a including PL/R as an option >>>>>> in the PostGIS installer could be useful - particularly if a set of >>>>>> pre-defined functions were included with the setup that made use of >>>>>> >>>> PL/R >>>> >>>>>> for spatial statistical operations within PostGIS. But this might >>>>>> >>>> get a >>>> >>>>>> bit complicated, considering the requirements involved (e.g., having R >>>>>> installed, as well as packages installed in R - such as deldir for >>>>>> making voronoi polygons). >>>>>> >>>>>> Mike >>>>>> >>>>>> TECHER David wrote: >>>>>> >>>>>>> Hi Jan, >>>>>>> >>>>>>> Before I made a mistake, all you want is only a win32-installer for >>>>>>> PL/R? >>>>>>> >>>>>>> because I think you know that's postgis win32-installer already >>>>>>> >>>> exist? >>>> >>>>>>> See http://www.postgis.org/download/windows/ >>>>>>> >>>>>>> --david; >>>>>>> >>>>>>> >>>>>>> Jan Hartmann a écrit : >>>>>>> >>>>>>>> Hi folks (sorry for crossposting), >>>>>>>> >>>>>>>> Joe Conway just announced that PL/R will soon be available for >>>>>>>> Windows. See the thread starting at: >>>>>>>> >>>>>>>> >>>>>>>> >>>> http://gborg.postgresql.org/pipermail/plr-general/2007-June/000235.html >>>> >>>>>>>> PL/R is an implementation of the statistical package R within >>>>>>>> PostgreSQL. See: >>>>>>>> >>>>>>>> http://www.joeconway.com/plr/ >>>>>>>> http://www.r-project.org <http://www.r-project.org/> >>>>>>>> >>>>>>>> It's installed the same way as postGIS, but until now only a Linux >>>>>>>> version was available. I have them both enabled on my server at SARA >>>>>>>> computing center, and the functionality is unbelievable. My own >>>>>>>> organisation, however, doesn't allow me to install Linux servers, >>>>>>>> >>>> and >>>> >>>>>>>> even if they did, neither staff nor students would be willing or >>>>>>>> >>>> even >>>> >>>>>>>> able to work with them. I guess this is not a unique situation, so >>>>>>>> this Windows port is really important. Moreover, a PostgreSQl >>>>>>>> implementation with full GIS and statistical functionality is >>>>>>>> something that doesn't exist in the commercial world as far as I >>>>>>>> >>>> know. >>>> >>>>>>>> An easy installable Windows version would IMO really be a showpiece >>>>>>>> for Open Source software. I would really appreciate if people in the >>>>>>>> know on both these lists would put their heads together to implement >>>>>>>> this. I don't really know much about Windows installers, but my >>>>>>>> feeling is that it is not enormously difficult. >>>>>>>> >>>>>>>> Regards, >>>>>>>> >>>>>>>> Jan Hartmann >>>>>>>> >>>>>>>> Dr. J. Hartmann >>>>>>>> Department of Geography >>>>>>>> University of Amsterdam >>>>>>>> _______________________________________________ >>>>>>>> postgis-users mailing list >>>>>>>> [email protected] >>>>>>>> http://postgis.refractions.net/mailman/listinfo/postgis-users >>>>>>>> >>>>>>>> >>>>>>> >>>>>>> >>>> ___________________________________________________________________________ >>>> >>>> >>>>>>> Yahoo! Mail r?invente le mail ! D?couvrez le nouveau Yahoo! Mail >>>>>>> >>>> et son >>>> >>>>>>> interface r?volutionnaire. >>>>>>> http://fr.mail.yahoo.com <http://fr.mail.yahoo.com/> >>>>>>> _______________________________________________ >>>>>>> postgis-users mailing list >>>>>>> [email protected] >>>>>>> http://postgis.refractions.net/mailman/listinfo/postgis-users >>>>>>> >>>>>>> >>>>>> _______________________________________________ >>>>>> postgis-users mailing list >>>>>> [email protected] >>>>>> http://postgis.refractions.net/mailman/listinfo/postgis-users >>>>>> >>>>>> >>>>> _______________________________________________ >>>>> postgis-users mailing list >>>>> [email protected] >>>>> http://postgis.refractions.net/mailman/listinfo/postgis-users >>>>> >>>>> >>>> >>>> >>>> >>>> ___________________________________________________________________________ >>>> >>>> Yahoo! Mail rinvente le mail ! Dcouvrez le nouveau Yahoo! Mail et son >>>> interface rvolutionnaire. >>>> http://fr.mail.yahoo.com <http://fr.mail.yahoo.com/> >>>> _______________________________________________ >>>> postgis-users mailing list >>>> [email protected] >>>> http://postgis.refractions.net/mailman/listinfo/postgis-users >>>> >>>> ------------------------------------------------------------------------ >>>> >>>> *The substance of this message, including any attachments, may be >>>> confidential, legally privileged and/or exempt from disclosure >>>> pursuant to Massachusetts law. It is intended solely for the >>>> addressee. If you received this in error, please contact the sender >>>> and delete the material from any computer. * >>>> >>>> ------------------------------------------------------------------------ >>>> >>>> _______________________________________________ >>>> postgis-users mailing list >>>> [email protected] >>>> http://postgis.refractions.net/mailman/listinfo/postgis-users >>>> >>>> >>> >>> >>> >>> >>> ___________________________________________________________________________ >>> Yahoo! Mail r?invente le mail ! D?couvrez le nouveau Yahoo! Mail et son >>> interface r?volutionnaire. >>> http://fr.mail.yahoo.com >>> _______________________________________________ >>> postgis-users mailing list >>> [email protected] >>> http://postgis.refractions.net/mailman/listinfo/postgis-users >>> >>> >> > > > > > > > ___________________________________________________________________________ > Yahoo! Mail réinvente le mail ! Découvrez le nouveau Yahoo! Mail et son > interface révolutionnaire. > http://fr.mail.yahoo.com > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
