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