[Qgis-user] setting graduated symbology for a small postgres point table crashing qgis.

[damien stephens]

never mind I figured it out.
the graduated engine does not like null values in the field, so i used a
calulated field:
case when field is null then .001 else field end

On Wed, Oct 11, 2023 at 4:41 PM damien stephens <damien.stephens at gmail.com>
wrote:

> Hi All.
> I have a point table view with around 50,000 records and 160 fields in
> postgres  which loads into qgis very quickly.
> the problem comes when i try to assign a graduated symbology.
> no matter which Mode i use - fixed interval, jenks etc, when i hit the
> classify button qgis freezes  - and had been frozen for around an hour.
> this has happened with 2 different views.
> anyone else seen this / have a fix.
> It could be a stupid mistake on my part as i am new to using Post gres, as
> trialling  it vs the current mssql setup.
> thanks in advance
> Damien
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20231011/e8e499a1/attachment.htm>