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

[Samuel Ingarfield]

Ah, perfect. Enclosing the query in brackets did the trick.
Thanks Jürgen!

Cheers;
Sam.

On Thu, May 26, 2016 at 8:48 PM, Jürgen E. <jef at norbit.de> wrote:

> 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 --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20160527/3f958593/attachment.html>