"posttime" time DEFAULT now() - Mailing list pgsql-sql

Hi

"posttime" time DEFAULT now()

I'm declaring a field called posttime (see above), which ofcourse stores
the time of a certain posting. It's nice to use a default value as
now(). But unfourtunatly, while creating the table, it generates the
following error:

ERROR:  Column "posttime" is of type time without time zone but default
expression is of type timestamp with time zone       You will need to rewrite or cast the expression

I prefer to ignore the timezone information... any hints?

NOTE: I've updated from 7.1 to 7.2b2 and before there was no problem
like this (exact same table existed on 7.1).


Thanks,
Koen Antonissen