Re: Error message and infinite date and timestamp conversion in XML

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Bernd Helmle <mailings(at)oopsware(dot)de>
Subject: Re: Error message and infinite date and timestamp conversion in XML
Date: 2009-04-08 21:52:39
Message-ID: 200904090052.40707.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Friday 27 March 2009 20:59:23 Tom Lane wrote:
> Done, but I noticed while testing that it's not real consistent:
>
> regression=# select xmlelement(name foo, 'infinity'::timestamp);
> ERROR: timestamp out of range
> DETAIL: XML does not support infinite timestamp values.
> regression=# select xmlelement(name foo,
> xmlattributes('infinity'::timestamp as bar)); xmlelement
> -----------------------
> <foo bar="infinity"/>
> (1 row)
>
> Should we consider doing something about that, or is it okay as-is?

Fixed. It was a bug.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2009-04-08 22:03:31 GUC inconsistency in 8.4?
Previous Message Tom Lane 2009-04-08 20:04:18 Re: problem with variable length user defined type