Hi Salvatore, I think that has just appeared from my editing the table names for including the query in this email.
DB manager will execute the query and give me the results in the Result section, it just won't add it to the map in 1.9. It will add it to the map in 1.7.4. If I save the project in 1.7.4 with the query in it, it will not open in 1.9. I think I have worked it out. The query returns the same polygon multiple times, and as such the gid column isn’t unique for each record. I guess I just need to only return each polygon once for QGIS to be able to use the query layer. James James Stott BSc (Hons) MSc | Senior Professional Nicholas Pearson Associates | 30 Brock Street | Bath | BA1 2LN T: 01225 445548 | M: - http://www.npaconsult.co.uk/ -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Salvatore Larosa Sent: 27 April 2012 10:38 To: [email protected] Subject: Re: [Qgis-user] PostGIS query running in 1.7.4 but not 1.9 Il giorno ven, 27/04/2012 alle 10.28 +0100, James Stott ha scritto: > I am trying to run a query in QGIS. The query below works in QGIS 1.7.4 > but I cannot get it to open in 1.9 (Windows 7). > > SELECT "units"."gid", "units"."name", "pipe"."section", > "units"."the_geom" > FROM "data"."units", "data"." pipe" > WHERE " pipe"."section" = 'W' and ST_DWithin("pipe"."the_geom", > "units"."the_geom", 500); > > Does anyone know what I am doing wrong? Hi James, I see a blank space in name table (pipe) in clause FROM: FROM "data"."units", "data"." pipe" Could be the problem there? Regards, -SL _______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user http://www.npaconsult.co.uk/http://www.npaconsult.co.uk/about-news.asp http://www.npaconsult.co.uk/terms.asp This Electronic Transmission is intended only for the attention of the addressee. It may contain privileged and confidential information. If you are not the person for whom it is intended, you must not copy, distribute or take any action in reliance on it. If you have received this electronic transmission in error please notify us immediately by telephone, delete the transmission and destroy any hard copies. Nicholas Pearson Associates has used all reasonable efforts to ensure that this message and any attachments are free from viruses. Nicholas Pearson Associates, 30 Brock Street, Bath, BA1 2LN , Tel: +44 (0) 01225 445548, Fax: +44 (0) 01225 312387, Website: http://www.npaconsult.co.uk/ _______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
