[Qgis-user] Question on Symbology and PostGIS

[Jan Michálek]

Maybe the problem is, than in char variable you should have fix count of
chars.

2014-12-29 0:27 GMT+01:00 Randal Hale <rjhale at northrivergeographic.com>:

>  On second thought - screenshot overshot the limit for the listserv.
>
> no - it wasn't really erroring out - just refusing to cooperate. I hope
> this screenshot Attaches properly.
>
> It categorizes properly in the Layer Properties. Lets try this ->
> https://www.dropbox.com/s/kz11etd72o6c4mx/category.bmp?dl=0
>
> The field called spacing is attributed properly. If I turn off the teal
> point all of them go off.
>
> It all seems to hinge on varchar vs char.
>
> I checked the error log and it's clean. Nothing out of the ordinary.
>
> I'm on Ubuntu 14.04 QGIS 2.6,  POSTGIS=2.1.3 r12547,  and PostgreSQL 9.3.5
>
> Randy
>
>
> On 12/28/2014 06:22 PM, Randal Hale wrote:
>
> no - it wasn't really erroring out - just refusing to cooperate. I hope
> this screenshot Attaches properly.
>
>
>
> The field called spacing is attributed properly. If I turn off the teal
> point all of them go off.
>
> It all seems to hinge on varchar vs char.
>
> I checked the error log and it's clean. Nothing out of the ordinary.
>
> I'm on Ubuntu 14.04 QGIS 2.6,  POSTGIS=2.1.3 r12547,  and PostgreSQL 9.3.5
>
> Randy
>
>
>
>
>
>
>
>
> On 12/28/2014 05:59 PM, Leknín Řepánek wrote:
>
> What was in error console written?
>
> On Sun, Dec 28, 2014 at 05:34:28PM -0500, Randal Hale wrote:
>
>  This might be something I should know. I have a point layer in
> postgres/postgis. It has three fields: name (varchar), CID ( primary key),
> and one called spacing (char).
>
> I tried to symbolize the point layer on the spacing attribute - it wouldn't.
> I made another field in postgis and called it spacing1 and made it varchar
> and it was no problem at all. Will QGIS not catergorically symbolize on a
> char field in postgis? Not a big deal as I can work around it - just curious
> though.
>
>
> Randy
>
>
> --
> -----------------
> Randal Hale
> North River Geographic Systems, Inchttp://www.northrivergeographic.com423.653.3611 rjhale at northrivergeographic.com
> twitter:rjhale     http://about.me/rjhalehttp://www.northrivergeographic.com/spatial-connect
>
> _______________________________________________
> Qgis-user mailing listQgis-user at lists.osgeo.orghttp://lists.osgeo.org/mailman/listinfo/qgis-user
>
>
> --
> -----------------
> Randal Hale
> North River Geographic Systems, Inchttp://www.northrivergeographic.com423.653.3611 rjhale at northrivergeographic.com
> twitter:rjhale     http://about.me/rjhalehttp://www.northrivergeographic.com/spatial-connect
>
>
> --
> -----------------
> Randal Hale
> North River Geographic Systems, Inchttp://www.northrivergeographic.com423.653.3611 rjhale at northrivergeographic.com
> twitter:rjhale     http://about.me/rjhalehttp://www.northrivergeographic.com/spatial-connect
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20141229/c31e0f1a/attachment.html>