Upgrade 7.3.3 to 7.4.5

От:

"Igor Kryltsov" <kryltsov@yahoo.com>

Дата:

1 октября 2004 г. в 20:16:46

Hi,

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

,where time is a time when psql -U postgres template1 < db_backup.sql was
executed.

I want to underline not all "timestamp default now()" columns but only some
of them.

Any ideas?


Thank you,

Igor

Re: Upgrade 7.3.3 to 7.4.5

От:

Tom Lane <tgl@sss.pgh.pa.us>

Дата:

1 октября 2004 г. в 22:19:34

"Igor Kryltsov"  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