[postgis-users] cannot retrieve any geometric data

[orkun]

hello

I cannot retrieve any geometric data with any select command :

select distinct(cat),astext(wkb_geometry) as geometry from jeopgis  
gives nothing.

here is my postgis structure:

bzk=# \d jeopgis
                                     Table "public.jeopgis"
    Column    |       Type        |                          Modifiers
--------------+-------------------+--------------------------------------------------------------
 ogc_fid      | integer           | not null default 
nextval('public.jeopgis_ogc_fid_seq'::text)
 wkb_geometry | geometry          |
 cat          | integer           |
 label        | character varying |
Indexes:
    "jeo_gidx" gist (wkb_geometry)
Check constraints:
    "enforce_srid_wkb_geometry" CHECK (srid(wkb_geometry) = 1)
    "enforce_dims_wkb_geometry" CHECK (ndims(wkb_geometry) = 2)
    "enforce_geotype_wkb_geometry" CHECK (geometrytype(wkb_geometry) = 
'POLYGON'::text OR wkb_geometry IS NULL)


what might be the problem ?

regards

Ahmet Temiz


______________________________________
XamimeLT - installed on mailserver for domain @deprem.gov.tr
Queries to: postmaster at deprem.gov.tr
______________________________________
The views and opinions expressed in this e-mail message are the sender's own
and do not necessarily represent the views and the opinions of Earthquake Research Dept.
of General Directorate of Disaster Affairs.

Bu e-postadaki fikir ve gorusler gonderenin sahsina ait olup, yasal olarak T.C.
B.I.B. Afet Isleri Gn.Mud. Deprem Arastirma Dairesi'ni baglayici nitelikte degildir.