Bug report #18356

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

Added by Rui Pedro Henriques about 6 years ago. Updated about 5 years ago.

Status:Open
Priority:Normal
Assignee:-
Category:DB Manager
Affected QGIS version:3.4.4 Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:
Crashes QGIS or corrupts data:No Copied to github as #:26246

Description

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 (96.4 KB) Rui Pedro Henriques, 2018-03-06 05:13 PM

pt_conc_grid25_4326_clip.gpkg - clipped part. original too big. same problem. (1.82 MB) Rui Pedro Henriques, 2018-03-06 05:17 PM

bug.JPG (94.8 KB) Federico Gianoli, 2019-02-23 03:22 PM

History

#1 Updated by Giovanni Manghi about 6 years ago

  • Operating System deleted (QGIS 2.18.15/win 10 and QGIS 2.18.0 on MacOS)
  • Subject changed from DB Manager - import layer into Postgis to DB Manager: import layer into Postgis fails with "Error 5 Creation of fields failed."
  • Affected QGIS version changed from 2.18.15 to 2.18.16

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

#2 Updated by Jürgen Fischer about 5 years ago

  • Status changed from Open to Feedback

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

#3 Updated by matteo ghetta about 5 years ago

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.

#4 Updated by Giovanni Manghi about 5 years ago

  • Status changed from Feedback to Open
  • Affected QGIS version changed from 2.18.16 to 3.4.4

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.

#5 Updated by Federico Gianoli about 5 years ago

The error, with this dataset, persist on QGIS 3.4.4

Error 4
Creation of fields failed

Also available in: Atom PDF