[postgis-users] Error while importing data

strk at refractions.net strk at refractions.net
Sun Jun 5 02:32:15 PDT 2005


What encoding does your database have ?
Which architecture are you on ?
--strk;

On Sat, Jun 04, 2005 at 02:48:09AM +0000, Aditya wrote:
> On Sat, Jun 04, 2005 at 02:36:57AM +0200, strk at refractions.net wrote:
> > I downloaded your .sql file and it loads fine here:
> [...]
> > Postgis version is 1.0.1 installed from official package.
> > 
> > Another question: can you send description of your geometry_columns table ?
> 
> Let me know if you want more than this:
> 
> grot=> \d geometry_columns
>             Table "public.geometry_columns"
>       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
> Indexes:
>     "geometry_columns_pk" PRIMARY KEY, btree (f_table_catalog, f_table_schema,
> f_table_name, f_geometry_column)
> 
> grot=> \d geometry_columns_pk
>      Index "public.geometry_columns_pk"
>       Column       |          Type
> -------------------+------------------------
>  f_table_catalog   | character varying(256)
>  f_table_schema    | character varying(256)
>  f_table_name      | character varying(256)
>  f_geometry_column | character varying(256)
> primary key, btree, for table "public.geometry_columns"
> 
> grot=> select * from geometry_columns ;
>  f_table_catalog | f_table_schema | f_table_name | f_geometry_column |
> coord_dimension | srid | type
> -----------------+----------------+--------------+-------------------+-----------------+------+------
> (0 rows)
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users



More information about the postgis-users mailing list