"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