Thanks for your fast response Sean. I'm not setup for mapscript, python, or compiling mapserver. One of these days I'll have to learn these things.
So I must ask that someone else in the community jumps in and confirms the patch for bug 1443. Thanks, Ken Lord Vancouver BC On 12/10/05, Sean Gillies <[EMAIL PROTECTED]> wrote: > Ken, > > Cc yourself to bug 1443. I committed a fix for it and would > appreciate confirmation. > > Sean > > On Dec 10, 2005, at 8:05 PM, Ken Lord wrote: > > > Here's a temporary fix that may work for certain users for the USING > > error for PostgreSQL 8.0.3 - PostGIS / mapserver 4.8b2 until the > > problem is patched. > > > > If your dataset is in the same map projection as your output map, > > simply remove the 'USING srid=3Dxxxxx' from the end of your SQL > > query in > > your DATA string. > > > > You will again be able to use nested select statements for datasets > > based on on-the-fly spatial queries etc. > > > > As Daryl Herzmann appears to have discovered, the current bug prevents > > mapserver from dealing with more than one USING tag in your SQL. > > > > Paul - Instead of waiting til Monday, I replicated the problem by > > upgrading my cariboo-gold.no-ip.info website to MS 4.8b2, to try your > > suggestion of turning on statement logging. > > > > - The log shows the same error seen on the webpage '.... syntax error > > at or near "USING" at character ...' So the database is receiving the > > request. > > > > And without the 'USING srid=3Dxxxxx' in the SQL statement, each map > > request crams the log with ~30 lines reffering to the 'find_srid' > > function ... but the map generates properly. > > > > Cheers, > > Ken Lord > > Vancouver BC > > > > > > > > On 12/10/05, Ken Lord <[EMAIL PROTECTED]> wrote: > >> Thanks Daryl, > >> > >> I saw your patch there, unfortunately I'm one of those hobbled > >> people > >> living in the windows world, who hasn't learned how to compile the > >> software. > >> > >> So it will be 4.8b3 or beyond for me :) > >> > >> Cheers, > >> Ken Lord > >> Vancouver BC > >> > >> On 12/10/05, Daryl Herzmann <[EMAIL PROTECTED]> wrote: > >>> On Sat, 10 Dec 2005, Ken Lord wrote: > >>> > >>>> Thanks Howard, > >>>> > >>>> That bug does seem to cover my problem, I've added a post to the > >>>> report to confirm that it affects more than just postgresql 8.1 + > >>>> mapserver 4.8b2. > >>>> > >>>> Paul, I'll try your suggestion on Monday. I had simplified my SQL > >>>> statement when trying to make it work, evidently I could have > >>>> simplified it more :) > >>>> > >>>> On 12/10/05, Howard Butler <[EMAIL PROTECTED]> wrote: > >>>>> Is <http://mapserver.gis.umn.edu/bugs/show_bug.cgi?id=3D1443> > >>>>> still relevant to this issue (issues with using *both* UNIQUE > >>>>> and SR= > > ID)? > >>> > >>> Hi Ken, > >>> > >>> I am nearly positive if you apply my patch included in that bug, > >>> Postgi= > > s > >>> with "USING..." in the data statement will work... > >>> > >>> Hopefully that patch, in some form, is accepted before the next > >>> release= > > ... > >>> > >>> daryl > >>> > >>> -- > >>> /** > >>> * Daryl Herzmann ([EMAIL PROTECTED]) > >>> * Program Assistant -- Iowa Environmental Mesonet > >>> * http://mesonet.agron.iastate.edu > >>> */ > >>> > >>> > >> > > --- > Sean Gillies > sgillies at frii dot com > http://zcologia.com/news >
