Michael Fuhr <mike(at)fuhr(dot)org> writes:
> On Fri, Mar 09, 2007 at 04:55:59AM -0800, psmith wrote:
>> When change a column type from timestamp to date, the 'infinity' and '-
>> infinity' values will be NULL. Even if the column has a not null
>> constraint.
> This appears to be fixed already:
http://archives.postgresql.org/pgsql-bugs/2006-07/msg00015.php
http://archives.postgresql.org/pgsql-committers/2006-07/msg00067.php
regards, tom lane