Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> writes:
> Thank you Tom for explanation. It's not very bothered me as far as I have
> many workarounds suggested in mailing list. But I wondering because
> 'now'::text works as expected when I create view
Yes, it's just the context of a DEFAULT expression that has these
problems. (Actually, it looks like constraints --- CHECK() expressions
--- are handled in the same bogus way, but we don't seem to get as many
gripes about them...)
regards, tom lane