Postgres Pro
Downloads
Home   >   mailing lists

Thread: British Double Summer Time

British Double Summer Time

From
Patrick Welche
Date:
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

Re: British Double Summer Time

From
Thomas Lockhart
Date:
> 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

Re: British Double Summer Time

From
Thomas Lockhart
Date:
> 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...

                         - ThomasIndex: datetime.c
===================================================================
RCS file: /home/thomas/cvs/repository/pgsql/src/backend/utils/adt/datetime.c,v
retrieving revision 1.76
diff -c -r1.76 datetime.c
*** datetime.c    2001/10/28 06:25:51    1.76
--- datetime.c    2001/11/05 14:41:12
***************
*** 92,97 ****
--- 92,98 ----
      {"awsst", DTZ, 54},            /* W. Australia */
      {"awst", TZ, 48},            /* W. Australia */
      {DB_C, ADBC, BC},            /* "bc" for years < 0 */
+     {"bdst", TZ, 12},            /* British Double Summer Time */
      {"bst", TZ, 6},                /* British Summer Time */
      {"bt", TZ, 18},                /* Baghdad Time */
      {"cadt", DTZ, 63},            /* Central Australian DST */

Re: British Double Summer Time

From
Patrick Welche
Date:
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