Bug report #1230
SPIT: 'SET SEARCH_PATH TO NULL' yields an error
| 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
fix #1230
git-svn-id: http://svn.osgeo.org/qgis/trunk/qgis@9112 c8812cc2-4d05-0410-92ff-de0c093fc19c
fix #1230
git-svn-id: http://svn.osgeo.org/qgis/trunk@9112 c8812cc2-4d05-0410-92ff-de0c093fc19c
History
#1
Updated by Jürgen Fischer over 16 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 over 15 years ago
Milestone Version 1.0.0 deleted