[Qgis-user] Problem with adding a PostGIS query using Python

[James Stott]

I cannot seem to get this query to work. The python code I am using is:

            db_conn = "dbname=database' host=SERVER port=5432
user='postgres' password='xxxx'"
            id_field = "gid"
            table="(SELECT * FROM \"designations\".\"table\" WHERE
ST_DWithin(ST_GeomFromText('POINT(451583 129144)',27700),
\"table\".\"geom\", 2000))"
            uri = "%s key=%s table=%s (geom) sql=" %
(db_conn,id_field,table,)
            layer = QgsVectorLayer(uri, "testlayer", "postgres")
            QgsMapLayerRegistry.instance().addMapLayer(layer)

QGIS keeps telling me the following:

Unable to access the "(""SELECT" relation. The error message from the
database was: ERROR: relation "("SELECT" does not exist LINE 1: SELECT *
FROM "(""SELECT" LIMIT 1

It's almost as if something is automatically putting another SELECT
statement in front of my SELECT statement.

I can get this query to load using the DB manager plugin SQL window.

I have read this article and it still errors.

http://www.carsonfarmer.com/?p=713

Does anyone know why this doesn't work?

Using QGIS 1.8 on Windows 7 64bit, data is in a PostGIS 2.0 database.

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/ 

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/