Nick Martens <[EMAIL PROTECTED]> writes:
> Jan 10 17:14:40 dndwebdev01 postgres[17374]: [1-1] ERROR: unrecognized time
> zone name: "America/Indiana"
> Jan 10 17:14:40 dndwebdev01 kernel: pid 17374 (postgres), uid 70: exited on
> signal 11 (core dumped)
Doesn't happen for me:
regression=# set timezone = 'America/Indiana';
ERROR: unrecognized time zone name: "America/Indiana"
regression=# set timezone = 'America/Indiana';
ERROR: unrecognized time zone name: "America/Indiana"
regression=# set timezone = 'America/Indiana';
ERROR: unrecognized time zone name: "America/Indiana"
regression=#
(This is with 8.0.6, but I don't see any related fixes in the CVS logs.)
Can you get a stack trace from the core dump?
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
