Jeevan Chalke <jeevan(dot)chalke(at)enterprisedb(dot)com> writes:
> While setting timezone using SET command (say GMT+3:30), postgres sometimes
> crashes randomly.
I can't reproduce that:
regression=# SET TimeZone = 'GMT+3:30';
SET
regression=# SELECT '1969-12-31 20:30:00'::timestamptz;
timestamptz
---------------------------
1969-12-31 20:30:00-03:30
(1 row)
regards, tom lane