DB Manager: import layer into Postgis fails with "Error 5 Creation of fields failed."

[qgib]

Author Name: Rui Pedro Henriques (Rui Pedro Henriques)
Original Redmine Issue: 18356
Affected QGIS version: 3.4.4
Redmine category:db_manager

---

When trying to import a layer to Postgis I get "Error 5 Creation of fields failed."
The table and fields id and geom are created on the DB.

It was tested on QGIS 2.18.15/win 10 and QGIS 2.18.0 on MacOS.

---

• Screen Shot 2018-03-06 at 15.59.57.png (Rui Pedro Henriques)
• pt_conc_grid25_4326_clip.gpkg (Rui Pedro Henriques)
• bug.JPG (Federico Gianoli)

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

Confirmed also on Linux. (Ricardo?) can you test also QGIS 3? Thanks.

---

• operating_system was changed from QGIS 2.18.15/win 10 and QGIS 2.18.0 on MacOS to
• subject was changed from DB Manager - import layer into Postgis to DB Manager: import layer into Postgis fails with "Error 5 Creation of fields failed."
• version was changed from 2.18.15 to 2.18.16

[qgib]

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

---

Please test with QGIS 3.4 - QGIS 2.18 reached it's end of life.

---

• status_id was changed from Open to Feedback

[qgib]

Author Name: matteo ghetta (@ghtmtt)

---

Confirmed also on 3.4 but only with the attached data and not with other data. So I suspect something is weird on data side.

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

matteo ghetta wrote:

Confirmed also on 3.4 but only with the attached data and not with other data. So I suspect something is weird on data side.

please bump affected version if necessary.

---

• status_id was changed from Feedback to Open
• version was changed from 2.18.16 to 3.4.4

[qgib]

Author Name: Federico Gianoli (Federico Gianoli)

---

The error, with this dataset, persist on QGIS 3.4.4

Error 4
Creation of fields failed

---

• 14409 was configured as bug.JPG

---

• bug.JPG (Federico Gianoli)

[gioman]

The error message is clearer now

ERROR: column name "xmin" conflicts with a system column name

as "xmin" is a reserved column name in pgsql https://www.postgresql.org/docs/12/ddl-system-columns.html