Style Categorized not working with PostGis database

[qgib]

Author Name: baditaflorin - (baditaflorin -)
Original Redmine Issue: 13144
Affected QGIS version: master
Redmine category:symbology

---

I have a database with around 200.000.000 points, where i filtered only 2.800.000 points.

I am trying to Style them based on a attribute.

When i click on Classify, nothing happens.

I also looked at pg_stat_activity and QGIS it`s not even trying to do a query and return a result.

---

• Capture_2_8_2.PNG (baditaflorin -)
• Capture_2_9.PNG (baditaflorin -)
• Capture_pgadmin2_9.PNG (baditaflorin -)

[qgib]

Author Name: baditaflorin - (baditaflorin -)

---

This seems like a regression, tested in 2.8.2 and it`s working.

---

• 8939 was configured as Capture_2_8_2.PNG
• fixed_version_id was configured as Future Release - High Priority

---

• Capture_2_8_2.PNG (baditaflorin -) - In qgis 2.8.2 it is working

[qgib]

Author Name: baditaflorin - (baditaflorin -)

---

• 8941 was configured as Capture_pgadmin2_9.PNG
• 8940 was configured as Capture_2_9.PNG

---

• Capture_pgadmin2_9.PNG (baditaflorin -) - 2.9 pgadmin - nopthing happens
• Capture_2_9.PNG (baditaflorin -) - 2.9 output

[qgib]

Author Name: baditaflorin - (baditaflorin -)

---

I have this problem also in 2.8.2 with ways

there is a hard coded limit atfer that QGIs fails directly ?

We should announce to the users then.

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

Any output in the log?

---

• status_id was changed from Open to Feedback

[qgib]

Author Name: baditaflorin - (baditaflorin -)

---

I think the problem it`s because i am using a view to see the 2.800.000

---

• fixed_version_id removed Future Release - High Priority

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

baditaflorin - wrote:

I think the problem it`s because i am using a view to see the 2.800.000

so you are trying to categorize a 2.8M records view from a 200M records dataset, stored on postgis?

what dataset is? what attribute are you using?

---

• category_id was configured as Symbology

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

Jürgen Fischer wrote:

Any output in the log?

closing for lack of feedback, please reopen if necessary.

---

• resolution was changed from to not reproducable
• status_id was changed from Feedback to Closed