Re: [Qgis-developer] QGIS allows to create tables with invalid field names?

2015-10-01 Thread Paolo Cavallini 
Il 01/10/2015 12:22, Sandro Santilli ha scritto:

> Are you referring to PostgreSQL tables ?
> IMHO the identifiers should just be quoted:

not tested with pg, noticed with shp.
thanks.

-- 
Paolo Cavallini - www.faunalia.eu
QGIS & PostGIS courses: http://www.faunalia.eu/training.html
___
Qgis-developer mailing list
Qgis-developer@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-developer

Re: [Qgis-developer] QGIS allows to create tables with invalid field names?

2015-10-01 Thread Sandro Santilli 
On Thu, Oct 01, 2015 at 12:07:36PM +0200, Paolo Cavallini wrote:
> Hi all,
> I just discovered that QGIS allows you to create a tabel with invalid
> column names (e.g. "1"). As a consequence, further commands may
> obviously fail. IMHO we shouldn't allow invalid names.
> Opinions?

Are you referring to PostgreSQL tables ?
IMHO the identifiers should just be quoted:

 strk=# create table test ("1" int);
 CREATE TABLE

--strk;
___
Qgis-developer mailing list
Qgis-developer@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-developer

[Qgis-developer] QGIS allows to create tables with invalid field names?

2015-10-01 Thread Paolo Cavallini 
Hi all,
I just discovered that QGIS allows you to create a tabel with invalid
column names (e.g. "1"). As a consequence, further commands may
obviously fail. IMHO we shouldn't allow invalid names.
Opinions?
Thanks.
-- 
Paolo Cavallini - www.faunalia.eu
QGIS & PostGIS courses: http://www.faunalia.eu/training.html
___
Qgis-developer mailing list
Qgis-developer@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-developer