Обсуждение: 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... 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
> 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
> 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 */
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