[TinyOWS-users] Error DescribeFeatureType request

[Leukert, Boris]

Dear Olivier,
thanks for your incredible fast help. r447 solved the problem for me.

But now I have the next problem with some data types of my PostgreSQL
table.
The table parcels_digitized has the following columns / data Types:

  gid serial NOT NULL,
  farm_id character varying NOT NULL,
  fiscal_year numeric(4,0) NOT NULL,
  status numeric(1,0) NOT NULL,
  sirsup_code integer NOT NULL,
  bloc_nr integer NOT NULL,
  parcel_nr integer NOT NULL,
  crop_nr character(1) NOT NULL,
  cat_use character varying NOT NULL,
  crop_code integer NOT NULL,
  area_declared numeric(9,2) NOT NULL,
  agro_env character varying NOT NULL,
  parcel_note character varying(255),
  inserted timestamp without time zone NOT NULL,
  updated timestamp without time zone,
  full_bloc integer NOT NULL,
  the_geom geometry NOT NULL,
  editor character varying(50),
  date_confirm character(10),

When I make a DescribeFeatureType request with tinyows I get the
following output:

  <xs:element name="farm_id" type="string" nillable="false"
minOccurs="1" maxOccurs="1"/>
  <xs:element name="fiscal_year" type="string" nillable="false"
minOccurs="1" maxOccurs="1"/>
  <xs:element name="status" type="string" nillable="false" minOccurs="1"
maxOccurs="1"/>
  <xs:element name="sirsup_code" type="int" nillable="false"
minOccurs="1" maxOccurs="1"/>
  <xs:element name="bloc_nr" type="int" nillable="false" minOccurs="1"
maxOccurs="1"/>
  <xs:element name="parcel_nr" type="int" nillable="false" minOccurs="1"
maxOccurs="1"/>
  <xs:element name="crop_nr" type="string" nillable="false"
minOccurs="1" maxOccurs="1"/>
  <xs:element name="cat_use" type="string" nillable="false"
minOccurs="1" maxOccurs="1"/>
  <xs:element name="crop_code" type="int" nillable="false" minOccurs="1"
maxOccurs="1"/>
  <xs:element name="area_declared" type="string" nillable="false"
minOccurs="1" maxOccurs="1"/>
  <xs:element name="agro_env" type="string" nillable="false"
minOccurs="1" maxOccurs="1"/>
  <xs:element name="parcel_note" type="string" nillable="true"
minOccurs="0" maxOccurs="1"/>
  <xs:element name="inserted" type="string" nillable="false"
minOccurs="1" maxOccurs="1"/>
  <xs:element name="updated" type="string" nillable="true" minOccurs="0"
maxOccurs="1"/>
  <xs:element name="full_bloc" type="int" nillable="false" minOccurs="1"
maxOccurs="1"/>
  <xs:element name="the_geom" type="gml:MultiPolygonPropertyType"
nillable="false" minOccurs="1" maxOccurs="1"/>
  <xs:element name="editor" type="string" nillable="true" minOccurs="0"
maxOccurs="1"/>
  <xs:element name="date_confirm" type="string" nillable="true"
minOccurs="0" maxOccurs="1"/>

The same request with Geoserver:

  <xsd:element maxOccurs="1" minOccurs="1" name="farm_id"
nillable="false" type="xsd:string"/>
  <xsd:element maxOccurs="1" minOccurs="1" name="fiscal_year"
nillable="false" type="xsd:decimal"/>
  <xsd:element maxOccurs="1" minOccurs="1" name="status"
nillable="false" type="xsd:decimal"/>
  <xsd:element maxOccurs="1" minOccurs="1" name="sirsup_code"
nillable="false" type="xsd:int"/>
  <xsd:element maxOccurs="1" minOccurs="1" name="bloc_nr"
nillable="false" type="xsd:int"/>
  <xsd:element maxOccurs="1" minOccurs="1" name="parcel_nr"
nillable="false" type="xsd:int"/>
  <xsd:element maxOccurs="1" minOccurs="1" name="crop_nr"
nillable="false" type="xsd:string"/>
  <xsd:element maxOccurs="1" minOccurs="1" name="cat_use"
nillable="false" type="xsd:string"/>
  <xsd:element maxOccurs="1" minOccurs="1" name="crop_code"
nillable="false" type="xsd:int"/>
  <xsd:element maxOccurs="1" minOccurs="1" name="area_declared"
nillable="false" type="xsd:decimal"/>
  <xsd:element maxOccurs="1" minOccurs="1" name="agro_env"
nillable="false" type="xsd:string"/>
  <xsd:element maxOccurs="1" minOccurs="0" name="parcel_note"
nillable="true" type="xsd:string"/>
  <xsd:element maxOccurs="1" minOccurs="1" name="inserted"
nillable="false" type="xsd:dateTime"/>
  <xsd:element maxOccurs="1" minOccurs="0" name="updated"
nillable="true" type="xsd:dateTime"/>
  <xsd:element maxOccurs="1" minOccurs="1" name="full_bloc"
nillable="false" type="xsd:int"/>
  <xsd:element maxOccurs="1" minOccurs="1" name="the_geom"
nillable="false" type="gml:MultiPolygonPropertyType"/>
  <xsd:element maxOccurs="1" minOccurs="0" name="editor" nillable="true"
type="xsd:string"/>
  <xsd:element maxOccurs="1" minOccurs="0" name="date_confirm"
nillable="true" type="xsd:string"/>

The "translation" of data types character and integer is O.K. but
numeric and timestamp does not work.

Best regards,
Boris