| From: | Lynn Dobbs <lynn(dot)dobbs(at)creditlink(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | xmlelement AND timestamps. |
| Date: | 2017-02-13 22:56:39 |
| Message-ID: | 4aae1b54-2f30-4d14-254d-e7bcffaf73e5@creditlink.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Mead | 2017-02-14 00:00:55 | Re: Re: Causeless CPU load waves in backend, on windows, 9.5.5 (EDB binary). |
| Previous Message | David Hinkle | 2017-02-13 22:44:32 | Re: Bad planning data resulting in OOM killing of postgres |