Opened 16 years ago

Closed 16 years ago

Last modified 15 years ago

#1230 closed bug (fixed)

SPIT: 'SET SEARCH_PATH TO NULL' yields an error

Reported by: msieczka Owned by: nobody
Priority: critical: causes crash or data corruption Milestone:
Component: SPIT Version: Trunk
Keywords: Cc:
Must Fix for Release: Yes Platform: Debian
Platform Version: Awaiting user input: no

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
  1. connect to a database
  1. choose 'Public' schema
  1. 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>

Change History (2)

comment:1 by jef, 16 years ago

Resolution: → fixed
Status: new → closed

not reproducable here, but r9112 should still fix it.

comment:2 by (none), 15 years ago

Milestone: Version 1.0.0

Milestone Version 1.0.0 deleted

Note: See TracTickets for help on using tickets.