I just migrated from 9.2.4 to 9.6.1 and had several user created
functions fail.
Recreating the failure with "SELECT xmlelement(name foo,
'infinity'::timestamp)
ERROR: timestamp out of range
DETAIL: XML does not support infinite timestamp values.
I don't find anything in the documentation that explains this. I
consider this a regression.
I have many tables that have a "starting" and "ending" timestamp that
default to "-infinity"
and "infinity" respectively. Any function I have that outputs xml
containing those columns
have to have those values cast to text.
Lynn Dobbs
--
Chief Technical Office
CreditLink Corporation
858-496-1000 x 103
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general