On 02/13/2017 02:56 PM, Lynn Dobbs wrote:
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.
All I could find was this thread from 2009: https://www.postgresql.org/message-id/41F26B729B014C3E8F20F5B7%40teje which indicated it was fixed at that time.
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
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
