Bug report #1230

SPIT: 'SET SEARCH_PATH TO NULL' yields an error

Added by Maciej Sieczka - about 12 years ago. Updated about 11 years ago.

Status:Closed
Priority:Low
Assignee:nobody -
Category:-
Affected QGIS version: Regression?:No
Operating System:Debian Easy fix?:No
Pull Request or Patch supplied: Resolution:fixed
Crashes QGIS or corrupts data: Copied to github as #:11290

Description

QGIS SVN trunk r9094, PostgreSQL 8.2.7, PostGIS 1.3.3, QT 4.4.0

Debian testing amd64.

1. add a Shapefile in SPIT

2. connect to a database

3. choose 'Public' schema

4. press OK - the import fails, with an error:

Problem inserting features from file:
/home/shoofi/gis/dane/WDPE/NATpntpol/Poland_NP_poly.shp
<p>Error while executing the SQL:</p><p>SET SEARCH_PATH TO NULL,'public'</p><p>The database said:ERROR:  syntax error at or near "NULL" 
LINE 1: SET SEARCH_PATH TO NULL,'public'
                           ^
</p>

Associated revisions

Revision 575c97f9
Added by Jürgen Fischer about 12 years ago

fix #1230

git-svn-id: http://svn.osgeo.org/qgis/trunk/[email protected] c8812cc2-4d05-0410-92ff-de0c093fc19c

Revision d7717556
Added by Jürgen Fischer about 12 years ago

fix #1230

git-svn-id: http://svn.osgeo.org/qgis/[email protected] c8812cc2-4d05-0410-92ff-de0c093fc19c

History

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

  • Resolution set to fixed
  • Status changed from Open to Closed

not reproducable here, but d7717556 (SVN r9113) should still fix it.

#2 Updated by Anonymous about 11 years ago

Milestone Version 1.0.0 deleted

Also available in: Atom PDF