[Qgis-user] PostGIS query running in 1.7.4 but not 1.9

[Salvatore Larosa]

Il giorno ven, 27/04/2012 alle 10.51 +0100, James Stott ha scritto:
> 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, what is the error throws it?

Also, check log messages!