Re: [GENERAL] xmlelement AND timestamps.

2017-02-14 Thread Lynn Dobbs
Well, I couldn't reproduce allowing infinite timestamps in 9.2.4 either. While fixing some other minor issues that came up in the migration to 9.6.1, I copied a replaced good functions with bad ones. The good functions called another function when putting my starting,ending columns in xml. T

Re: [GENERAL] xmlelement AND timestamps.

2017-02-13 Thread David G. Johnston
On Mon, Feb 13, 2017 at 7:10 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > XML itself is textual and we don't have any internal support for DTD or > Schema as it is so I'm not sure what material benefit we gain by > restraining ourselves here. > ​This apparently isn't true - the XM

Re: [GENERAL] xmlelement AND timestamps.

2017-02-13 Thread Tom Lane
Lynn Dobbs writes: > 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 a

Re: [GENERAL] xmlelement AND timestamps.

2017-02-13 Thread David G. Johnston
On Mon, Feb 13, 2017 at 6:36 PM, Adrian Klaver wrote: > 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 o

Re: [GENERAL] xmlelement AND timestamps.

2017-02-13 Thread Adrian Klaver
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'

[GENERAL] xmlelement AND timestamps.

2017-02-13 Thread Lynn Dobbs
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 tha