Re: 7.4 compatibility question

Tom Lane wrote:
> Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> writes:
> >>> Now that DEFAULT 'now' will not work in PostgreSQL 7.4, will DEFAULT
> >>> 'infinity' and DEFAULT '-infinity' and the like stop working as well?
> >>
> >> No, because those values don't change over time. The issue here is when
> >> exactly does the default value get evaluated...
>
> > Ah, of course - but what about 'yesterday' and 'tomorrow' - these should
> > also be mentioned in the release notes.
>
> Good point ... not that I think anyone is actually using such a default
> in the field, but the behavior did change ...

It would be pretty strange to use those as a default --- I am not
inclined to mention it in the release notes --- we don't mention every
change, only significant ones.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073