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=xxxxx' 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=xxxxx' 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=1443> > > >> still relevant to this issue (issues with using *both* UNIQUE and SRID)? > > > > Hi Ken, > > > > I am nearly positive if you apply my patch included in that bug, Postgis > > 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 > > */ > > > > >
