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

[Andreas Neumann]

Hi Damien,

Can you submit a bug report please?

NULL values in the data shouldn't make QGIS freeze.

Thanks,
Andreas

On Wed, 11 Oct 2023 at 10:51, damien stephens via QGIS-User <
qgis-user at lists.osgeo.org> wrote:

> 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
>>
>>
>> _______________________________________________
> QGIS-User mailing list
> QGIS-User at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>


-- 

--
Andreas Neumann
QGIS.ORG board member (treasurer)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20231011/59f3fe40/attachment.htm>