[postgis-users] OT: Question on performance in plpgsql function

2011-09-05 Thread Stephen Woodbridge
Hi all, This may be a little off topic, but there are a lot of smart minds here that might know. I have a plpgsql function the does some work to compute all the intersections with street names in a road network. It creates a vertex table like in pgrouting and an intersection table. Then popu

Re: [postgis-users] compile on solaris 11 sparc

2011-09-05 Thread Paul Ramsey
Yeah, I was going to ask a similar question: we want a tool that does everything cpp does (replacements, inclusions, conditions), but isn't cpp? P. On Mon, Sep 5, 2011 at 8:06 AM, Chris Hermansen wrote: > Please pardon my ignorance of all things windows but is the cpp not one of > those universa

Re: [postgis-users] compile on solaris 11 sparc

2011-09-05 Thread Chris Hermansen
Please pardon my ignorance of all things windows but is the cpp not one of those universal components of the c programming environment? (apologies in advance I know.this is not a postgis question) On Sep 5, 2011 4:51 AM, "Mark Cave-Ayland" wrote: > On 02/09/11 18:02, Doug McComber wrote: > >> I'v

Re: [postgis-users] compile on solaris 11 sparc

2011-09-05 Thread Mark Cave-Ayland
On 02/09/11 18:02, Doug McComber wrote: I've got this in my profile: # 64 bit compiling CC="gcc" CXX="g++" CPP="gcc" CFLAGS="-m64" CPPFLAGS="-m64" CXXFLAGS="-m64" # 3rd party libray LDFLAGS="-L/usr/local/lib" and ran source ~/.profile Despite that I found I had to add some of that to the con