ogr2ogr fails to create multiple geometry columns on postgis when using the lco SCHEMA

[tumasgiu]

When using ogr2ogr command like this :

ogr2ogr.exe -lco SCHEMA=myschema -dialect SQLITE 
-f Postgresql PG:"dbname=test user='postgres'"  EDIGEOA1.THF 
-sql "SELECT foo.id,bar.geometry AS poly, foo.geometry AS point 
      FROM foo left join bar using id = ptr"

It fails at creating the new geometrycolumns. Inspecting the database log it seems that ogr2ogr try the following statement :

SELECT AddGeometryColumn('myschema','myschema.select','point',900915,'POINT',2)

which is wrong ( the second parameter must be table name only, not a full qualified name ).

A turnaround is to use the active_schema option of the PG connection string.

[Even Rouault]

branches/1.11 r30850 "PG: fix creation of multiple geometry fields with SCHEMA creation option (#6141)"

2.0 was already OK