id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc
4177	Can't append to a PostGIS table with no geometry	timneedham	warmerdam	"OGR2OGR 1.9:

If you create a PostGIS layer using OGR2OGR that has no geometry, then subsequently try to -append data to it you get:

ERROR 1: Layer xxxxx already exists, CreateLayer failed.

I'm importing gzipped GML into PostGIS.

The actual data being imported is Ordnance Survey (UK) mastermap... which contains many layers, two of which (road and roadlinkinformation) do not have geometry data associated with them.

There is a workaround... It seems ogr2ogr only considers PostGIS tables to ""exist"" if they're registered in public.geometry_columns, so by creating dummy records in there everything works.

- Brilliant product by the way! :)
"	defect	closed	normal		default	unspecified	normal	invalid	ogr2ogr append no geometry	
