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