"Igor Kryltsov" <[EMAIL PROTECTED]> writes:
> I upgraded recently DB and found that some columns with type "timestamp"
> changed default values from now() to:
>  receipt_date          | timestamp with time zone | not null default
> '2004-09-29 09:58:03.010678+10'::timestamp with time zone

Those were not defined as "default now()".  More likely they were
defined as "default 'now'", which doesn't work anymore.  See the release
notes.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org

Reply via email to