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

Sandro Santilli strk at keybit.net
Thu Oct 1 03:22:31 PDT 2015


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;


More information about the Qgis-developer mailing list