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

[damien stephens]

Thanks Andreas done.
#54921

On Wed, Oct 11, 2023 at 4:59 PM Andreas Neumann <andreas at qgis.org> wrote:

> 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/20231012/bba4746f/attachment.htm>