Hello,
Sorry to bother you with this, but I think there is a small problem
with copying abstimes in v6.1.
I noticed an increment of 1 hour to abstime fields when
copying tables back into the database using the 'copy from'
command.
An example:
> postgres=> create table test(modtime abstime);
> CREATE
> postgres=> insert into test values('Fri Apr 04 18:41:48 1997');
> INSERT 18446
> postgres=> select * from test;
> modtime
> --------------------------------
> Fri Apr 04 18:41:48 1997 MET DST
> (1 row)
>
> postgres=> copy test to '/tmp/test';
> COPY
> postgres=> ^Z
> [1]+ Stopped psql
> % cat /tmp/test
> Fri Apr 04 18:41:48 1997 MET DST
Ok. Now watch this:
> % fg
> psql
>
> postgres=> delete from test;
> DELETE
> postgres=> copy test from '/tmp/test';
> COPY
> postgres=> select * from test;
> modtime
> --------------------------------
> Fri Apr 04 19:41:48 1997 MET DST
^
> (1 row)
The time 18:41:48 has become 19:41:48. I just upgraded to v6.1 and this
has never happened before.
Platform is Linux 2.0.29. Compiler is gcc 2.7.2.1. C-library: 5.4.33
Any ideas?
Cheers,
Ronald
------------------------------
