Nick Martens <[EMAIL PROTECTED]> writes:
> i just tried the commands from the psql console, and seems to crash then too.
It turns out that the problem is specific to referencing a timezone name
that is a directory (rather than an individual datafile) in the timezone
database. In that case the tzload function manages to clobber some
state before realizing that it's looking at invalid data. Here's the
patch if you need it.
regards, tom lane
Index: localtime.c
===================================================================
RCS file: /cvsroot/pgsql/src/timezone/localtime.c,v
retrieving revision 1.9
diff -c -r1.9 localtime.c
*** localtime.c 1 Nov 2004 21:34:44 -0000 1.9
--- localtime.c 10 Jan 2006 20:05:06 -0000
***************
*** 842,862 ****
bool
pg_tzset(const char *name)
{
if (lcl_is_set && strcmp(lcl_TZname, name) == 0)
return true; /* no change */
if (strlen(name) >= sizeof(lcl_TZname))
return false; /* not gonna fit */
! if (tzload(name, lclptr) != 0)
{
! if (name[0] == ':' || tzparse(name, lclptr, FALSE) != 0)
{
/* Unknown timezone. Fail our call instead of loading
GMT! */
return false;
}
}
strcpy(lcl_TZname, name);
lcl_is_set = true;
--- 842,865 ----
bool
pg_tzset(const char *name)
{
+ struct state tmpmem;
+
if (lcl_is_set && strcmp(lcl_TZname, name) == 0)
return true; /* no change */
if (strlen(name) >= sizeof(lcl_TZname))
return false; /* not gonna fit */
! if (tzload(name, &tmpmem) != 0)
{
! if (name[0] == ':' || tzparse(name, &tmpmem, FALSE) != 0)
{
/* Unknown timezone. Fail our call instead of loading
GMT! */
return false;
}
}
+ memcpy(lclptr, &tmpmem, sizeof(struct state));
strcpy(lcl_TZname, name);
lcl_is_set = true;
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
