Re: date/time compatible problems in 7.2

Thomas Lockhart wrote:

> > I has pg_dump my DB in 7.1.3 and try ro pg_restore it in 7.2
> > version.
> > psql:/.../dbdump/.dbrestore.tmp:1624094: ERROR: copy: line 1, Bad
> > timestamp external representation 'Fri 25 Jan 23:59:59 2002 KRAT'
> > psql:/.../dbdump/.dbrestore.tmp:1624094: lost synchronization with
> > server, resetting connection
>
> Not sure why it is crashing. But "KRAT" is a time zone not recognized
by
> the PostgreSQL date/time parser. In fact it could be afaik (it is
> mentioned but commented-out in the parser) but it either had a screwy
> definition or I couldn't figure out what the definition was. It could
be
> added for 7.2.1 (and I could send a patch beforehand) if I knew the
> proper definition. Check src/backend/utils/adt/datetime.c and look for

> "krat".

KRAT,KRAST is timezone code generated by FreeBSD automatically.
You can check up /usr/share/zoneinfo - it have all timezones.
You can see timezones KRAT,KRAST in file
/usr/share/zoneinfo/Asia/Krasnoyarsk.

I already break idea to pg_dump in 7.1.3 and pg_restore in 7.2 and
tried to remove ' KRAT' substring from all my *.dat files, created
by
pg_dump and change schema to fields without timezone. After I tried
pg_restore only data from dbdump-file, but pg_restore says, that
can't initialize header from TOC-file, but I not even touched it.
TOC - is only one binary file in dbdump-file. I think that it also
have
smth like CRC code about all other files, and this is reason why
they
say that can't initialize TOC-file?

How to patch datetime.c to 7.2 permit my 'KRAT' timezone?

Greatly appreciate,
Ruslan A Dautkhanov