Thanks Andreas done. #54921 On Wed, Oct 11, 2023 at 4:59 PM Andreas Neumann <[email protected]> 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 < > [email protected]> 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 < >> [email protected]> 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 >> [email protected] >> 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 [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
