[postgis-users] Re: Error while importing data

[Aditya]

> On Sun, 5 Jun 2005 11:32:15 +0200, strk at refractions.net said:
> What encoding does your database have ?  Which architecture are you
> on ?  --strk;

ah ha! interesting questions that I thought you'd ask when you saw my previous email :-)

running on FreeBSD-CURRENT on sparc 64bit and encoding is the default, SQL_ASCII

grot=> select version();
                                              version
----------------------------------------------------------------------------------------------------
 PostgreSQL 8.0.3 on sparc64-unknown-freebsd6.0, compiled by GCC gcc (GCC) 3.4.2 [FreeBSD] 20040728
(1 row)

Thanks,
Adi

> 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