[QGIS-trac] [Quantum GIS] #1230: SPIT: 'SET SEARCH_PATH TO NULL' yields an error

[Quantum GIS]

#1230: SPIT: 'SET SEARCH_PATH TO NULL' yields an error
---------------------------------------------------------+------------------
   Reporter:  msieczka                                   |              Owner:  nobody       
       Type:  bug                                        |             Status:  new          
   Priority:  critical: causes crash or data corruption  |          Milestone:  Version 1.0.0
  Component:  SPIT                                       |            Version:  HEAD         
   Keywords:                                             |   Platform_version:               
   Platform:  Debian                                     |           Must_fix:  Yes          
Status_info:  0                                          |  
---------------------------------------------------------+------------------
 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>
 }}}

-- 
Ticket URL: <http://trac.osgeo.org/qgis/ticket/1230>
Quantum GIS <http://qgis.org>
Quantum GIS is an Open Source GIS viewer/editor supporting OGR, PostGIS, and GRASS formats