[postgis-users] cannot retrieve any geometric data

orkun temiz at deprem.gov.tr
Sun Sep 11 09:18:41 PDT 2005


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 
 wkb_geometry | geometry          |
 cat          | integer           |
 label        | character varying |
    "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 ?


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.

More information about the postgis-users mailing list