I dumped a 7.1devel database, and when reloading into postgres of 31 Oct
2001 20:23 GMT I get:

psql:foobar.db:60: ERROR:  copy: line 2247, Bad timestamp external
representation 'Fri 01 Aug 00:00:00 1941 BDST'
psql:foobar.db:60: lost synchronization with server, resetting connection

My zoneinfo files know about BDST, but src/backend/utils/adt/datetime.c
doesn't...

This may have been fixed within the last few days, and when I get to the
office I could see what changed in datetime.c, but I thought I would mention
it now..

Cheers,

Patrick

Sun, 4 Nov 2001 20:53:32 +0000
Patrick Welche <prlw1@newn.cam.ac.uk>
British Double Summer Time
> I dumped a 7.1devel database, and when reloading into postgres of 31 Oct
> 2001 20:23 GMT I get:
> psql:foobar.db:60: ERROR:  copy: line 2247, Bad timestamp external
> representation 'Fri 01 Aug 00:00:00 1941 BDST'
> psql:foobar.db:60: lost synchronization with server, resetting connection
> My zoneinfo files know about BDST, but src/backend/utils/adt/datetime.c
> doesn't...

In 6 years of date/time work, this is the first I've heard of "BDST".
Can you give me a definition? What is the "double" part of it?? Does it
actually stand for "British Daylight Savings Time"?

                         - Thomas

Mon, 05 Nov 2001 14:39:03 +0000
Thomas Lockhart <lockhart@fourpalms.org>
Re: British Double Summer Time
> My zoneinfo files know about BDST, but src/backend/utils/adt/datetime.c
> doesn't...

Not fixed yet, but I found the definition of BDST on line, and will
commit it soon.

If you need a fix earlier, here is a patch...

                         - Thomas
Mon, 05 Nov 2001 14:44:55 +0000
Thomas Lockhart <lockhart@fourpalms.org>
Re: British Double Summer Time
On Mon, Nov 05, 2001 at 02:44:55PM +0000, Thomas Lockhart wrote:
> > My zoneinfo files know about BDST, but src/backend/utils/adt/datetime.c
> > doesn't...
> 
> Not fixed yet, but I found the definition of BDST on line, and will
> commit it soon.
> 
> If you need a fix earlier, here is a patch...

That was quick! Thank you!

Patrick

Mon, 5 Nov 2001 16:24:50 +0000
Patrick Welche <prlw1@newn.cam.ac.uk>
Re: British Double Summer Time