Requested dates in feature type SiteSinglePhenomTimeSeries get timezone information
-----------------------------------------------------------------------------------
Key: GEOS-1919
URL: http://jira.codehaus.org/browse/GEOS-1919
Project: GeoServer
Issue Type: Bug
Components: Community schema
Environment: PostgreSQL database, BOM data
Reporter: Volker Mische
Assignee: Andrea Aime
The community schema has feature types that include a date. That date shouldn't contain any time information.
The SiteSinglePhenomTimeSeries feature type uses a view named "all_data" for its mapping. It is a union of the daily_rainfall, monthy_rainfall and yearly_rainfall tables. daily_rainfall, monthy_rainfall uses the type "date" for storing the date information; yearly_rainfall uses timestamptz (I can't see any reason why it shouldn't use "date" too).
It seems that if one type is of timestamptz the others get converted to that too. The result of the view has a date information of type timestamptz.
Further information and examples can be found at https://extranet.lisasoft.com/wiki/index.php/Software_Test_Results
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira