[postgis-users] cannot retrieve any geometric data
orkun
temiz at deprem.gov.tr
Sun Sep 11 09:18:41 PDT 2005
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.
More information about the postgis-users
mailing list