ogr2ogr -overwrite does not work if target is PostGIS table which name begins with "pg"

[niccolo]

Running ogr2ogr with option -overwrite and destination a PostGIS table which name begins with "pg": it does not execute the DROP TABLE statement, causing a subsequent PostgreSQL error:

ERROR:  relation "pgip_zone_2008" already exists

The problem is in ogr/ogrsf_frmts/pg/ogrpgdatasource.cpp: when searching for tables it imposes:

c.relname !~ '^pg'

I suppose it is to to skip PostgreSQL system tables, but this skips also user tables.

A slightly better approach is to skip "^pg_" prefix, but I suppose it can be even better.

[warmerdam]

Chaitanya,

Could you look into a safe fix for this issue?

[chaitanya]

According to the PostgreSQL documentation, it should be enough to avoid the pg_ prefix for table and schema names. This is the easiest method and is supposed to be future proof.

I'm applying niccolo's suggestion.

[chaitanya]

Fixed in trunk (r19141), 1.7 branch (r19142) and the 1.6 branch (r19143).