[Qgis-user] Very long sql in postgres layer definition

Jürgen E. Fischer jef at norbit.de
Thu May 26 05:48:05 PDT 2016


Hi Samuel,.

On Thu, 26. May 2016 at 15:33:44 +0800, Samuel Ingarfield wrote:
> I'm trying to load a postigs layer via python which is defined by a very
> long sql query. It seems that Qgis is truncating the query (which obviously
> causes it to fail). Has anyone come across this before and come up with a
> solution? Or am I loading the layer incorrectly?

Did you enclose the query in ()?

Jürgen

-- 
Jürgen E. Fischer           norBIT GmbH             Tel. +49-4931-918175-31
Dipl.-Inf. (FH)             Rheinstraße 13          Fax. +49-4931-918175-50
Software Engineer           D-26506 Norden             http://www.norbit.de
QGIS release manager (PSC)  Germany                    IRC: jef on FreeNode                         
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 827 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20160526/92448fbf/attachment.sig>


More information about the Qgis-user mailing list