Jeevan Chalke <jeevan.chalke@enterprisedb.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