[postgis-users] create a dataset with a name I already used before

[Markus Schaber]

Hi, Gregory,

Gregory S. Williamson wrote:
> Giorgio --
> 
> When a table is created with a spatial geometry column, an reference is put into a table called "geometry_columns" -- this might be what is causing your problem as when a table is fropped the reference remains in this table. In postGIS 0.7 this table looks like:
>       Column       |          Type          | Modifiers
> -------------------+------------------------+-----------
>  f_table_catalog   | character varying(256) | not null
>  f_table_schema    | character varying(256) | not null
>  f_table_name      | character varying(256) | not null
>  f_geometry_column | character varying(256) | not null
>  coord_dimension   | integer                | not null
>  srid              | integer                | not null
>  type              | character varying(30)  | not null
>  attrelid          | oid                    |
>  varattnum         | integer                |
>  stats             | histogram2d            |
> 
> In 1.0 the table is similar but missing the last 3 columns.

AFAIR, the last three columns are obsolete if you run PostgreSQL >= 8.0,
but not with PostGIS 1.X on a 7.4 PostgreSQL server.

Markus