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