Re: [BUGS] alter column type (from timestamp to date) violates not null

2007-03-10 Thread Michael Fuhr
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

Re: [BUGS] alter column type (from timestamp to date) violates not null

2007-03-10 Thread Tom Lane
Michael Fuhr [EMAIL PROTECTED] 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:

[BUGS] alter column type (from timestamp to date) violates not null

2007-03-09 Thread psmith
Hi! 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. Sorry, if it is a duplicated bug report. Regards, psmith Here is the test procedure: proba2=# create table a(t timestamp not null); CREATE