id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc
2945	postgres driver failes to create geometry index if layer name starts with a number	winkey	chaitanya	"
ERROR 1: 'CREATE INDEX 500hgt_geom_idx ON ""public"".""500hgt"" USING GIST (""wkb_geometry"")' failed for layer 500hgt, layer creation has failed.

index name needs to be quoted

in ogrpgdatasource.cpp around line 1291

{{{

            osCommand.Printf(""CREATE INDEX %s_geom_idx ON \""%s\"".\""%s\"" USING GIST (\""%s\"")"",
                    pszTableName, pszSchemaName, pszTableName, pszGFldName);

}}}

should be

{{{

            osCommand.Printf(""CREATE INDEX \""%s_geom_idx\"" ON \""%s\"".\""%s\"" USING GIST (\""%s\"")"",
                    pszTableName, pszSchemaName, pszTableName, pszGFldName);

}}}
"	defect	closed	normal	1.6.1	OGR_SF	unspecified	normal	fixed	postgres postgis PG	warmerdam