Re: date_trunc check constraint causes errors when restoring in a db with a different time zone

Thanks, that is helpful. There was a separate reason it didn't appear
to be happening before the 8.4 upgrade.
I couldn't find this mentioned in the documentation anywhere. Should
it be included in the pg_restore section?

-Anthony

On Sun, Jan 16, 2011 at 11:06 AM, Denish Patel <denish@omniti.com> wrote:
> Anthony,
> As per my knowledge, this can't work on pg84 dump/restore too. You should
> match timezone on restoring database with the dump database to load it
> successfully. You can set at user level or database level.
> =A0On restoring database:
> =A0=A0 ALTER DATABASE=A0test_db_2 SET TIMEZONE TO 'UTC';
> =A0=A0 =A0OR
> =A0=A0 ALTER USER postgres=A0SET TIMEZONE TO 'UTC';
> Hope , it will help.