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

[Gregory S. Williamson]

Interesting -- I hadn't noticed that; thanks for the correction!
G

-----Original Message-----
From:	postgis-users-bounces at postgis.refractions.net on behalf of Markus Schaber
Sent:	Wed 9/28/2005 4:18 AM
To:	PostGIS Users Discussion
Cc:	
Subject:	Re: [postgis-users] create a dataset with a name I already used before
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
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

!DSPAM:433a7c5d114331796514491!