Tables with SRID=0 appear twice in the Browser

[qgib]

Author Name: Paolo Cavallini (@pcav)
Original Redmine Issue: 15874
Affected QGIS version: 3.0.0
Redmine category:browser

---

A table created with SRID=0:

CREATE TABLE pt
 (id INTEGER, name text, geom GEOMETRY(Point,0,2));
INSERT INTO pt (id, name, geom)
 VALUES (1, 'Origin', ST_GeomFromText('POINT(0 0)', 0));

results in two entries: one with mouseover= geom as Point in 0 and one geom as Point in -2147483648

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• easy_fix was configured as 0
• regression was configured as 0

[qgib]

Author Name: Paolo Cavallini (@pcav)

---

Still true in QGIS 3

---

• version was changed from 2.18.0 to 3.0.0
• description was changed from A table created with SRID=0:

CREATE TABLE pt
 (id INTEGER, name text, geom GEOMETRY(Point,0,2));
INSERT INTO pt (id, name, geom)
 VALUES (1, 'Origin', ST_GeomFromText('POINT(0 0)', 0));

results in two entries: one with mouseover= geom as Point in 0 and one geom as Point in -2147483648 to A table created with SRID=0:

CREATE TABLE pt
 (id INTEGER, name text, geom GEOMETRY(Point,0,2));
INSERT INTO pt (id, name, geom)
 VALUES (1, 'Origin', ST_GeomFromText('POINT(0 0)', 0));

results in two entries: one with mouseover= geom as Point in 0 and one geom as Point in -2147483648

[Pedro-Murteira]

@pcav Hello, i've tested this on QGIS 3.22.3. Pg Admin 6.3 and I can't reproduce it. Did you come across this issue more recently?

[github-actions]

The QGIS project highly values your report and would love to see it addressed. However, this issue has been left in feedback mode for the last 14 days and is being automatically marked as "stale".
If you would like to continue with this issue, please provide any missing information or answer any open questions. If you could resolve the issue yourself meanwhile, please leave a note for future readers with the same problem and close the issue.
In case you should have any uncertainty, please leave a comment and we will be happy to help you proceed with this issue.
If there is no further activity on this issue, it will be closed in a week.

[github-actions]

While we hate to see this happen, this issue has been automatically closed because it has not had any activity in the last 42 days despite being marked as feedback. If this issue should be reconsidered, please follow the guidelines in the previous comment and reopen this issue.
Or, if you have any further questions, there are also further support channels that can help you.