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. [...] > version > -------------------------------------------------------------------------------------------------------------- > PostgreSQL 8.1.0 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.0.3 > 20051023 (prerelease) (Debian 4.0.2-3) > (1 sor)
This appears to be fixed already: test=> alter table a alter t type date; ERROR: column "t" contains null values test=> select version(); version --------------------------------------------------------------------------- PostgreSQL 8.1.8 on sparc-sun-solaris2.9, compiled by GCC gcc (GCC) 3.4.2 (1 row) -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings