Bug report #20521
I try to import a shapefile into postgres and i get this message
| 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 almost 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.