Bug report #20521

I try to import a shapefile into postgres and i get this message

Added by bill bakas about 6 years ago. Updated over 5 years ago.

Status:Closed
Priority:Normal
Assignee:-
Category:DB Manager
Affected QGIS version:3.4.1 Regression?:No
Operating System:win10 Easy fix?:No
Pull Request or Patch supplied:No Resolution:no timely feedback
Crashes QGIS or corrupts data:No Copied to github as #:28341

Description

I try to import a shapefile into postgres and i get this message:

Processing algorithm…
Algorithm 'Export to PostgreSQL' starting…
Input parameters: { 'CREATEINDEX' : True, 'DATABASE' : 'post_geodata_testdb', 'DROP_STRING_LENGTH' : False, 'ENCODING' : 'UTF-8', 'FORCE_SINGLEPART' : False, 'GEOMETRY_COLUMN' : 'geom', 'INPUT' : 'E:\\gla\\test_creates_in_qgis.shp', 'LOWERCASE_NAMES' : True, 'OVERWRITE' : True, 'PRIMARY_KEY' : None, 'SCHEMA' : 'public', 'TABLENAME' : '' }

Traceback (most recent call last):
File "C:/PROGRA~1/QGIS 3.4/apps/qgis/./python/plugins\processing\algs\qgis\ImportIntoPostGIS.py", line 185, in processAlgorithm
self.tr('Error importing to PostGIS\n{0}').format(exporter.errorMessage()))
_core.QgsProcessingException: Error importing to PostGIS
Creation of data source "public"."test_creates_in_qgis" failed:
ERROR: function addgeometrycolumn(unknown, unknown, unknown, integer, unknown, integer) does not exist
LINE 1: SELECT AddGeometryColumn('public','test_creates_in_qgis','ge...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.

Execution failed after 0.16 seconds

Loading resulting layers
Algorithm 'Export to PostgreSQL' finished

History

#1 Updated by Jürgen Fischer about 6 years ago

  • Status changed from Open to Feedback

verify that the postgis extension is loading into the database (CREATE EXTENSION postgis).

#2 Updated by Giovanni Manghi over 5 years ago

  • Resolution set to no timely feedback
  • Status changed from Feedback to Closed

Closing for lack of feedback.

Also available in: Atom PDF