Re: India time zone missing

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

"Sanjay" <sbanerji(at)bom(dot)direm(dot)com> writes:
> The India Time Zone (IST) which is 5:30 + ahead of UST / GMT is not availab=
> le in PostgreSQL.

Looks like the Israelis beat you to it:

	{"ist", TZ, POS(8)},		/* Israel */

This isn't the first such conflict we've heard about.  I suppose the
eventual solution will be to remove the built-in table of timezone names
in favor of a configuration file that defines the timezones to be used,
so that people could easily customize the zone names for local use.
This is not very high on the to-do list of any of the key developers,
however.  In the meantime you could just hack the timezone table (look
in src/backend/utils/adt/datetime.c).

> Also, India specific built in conversions (e.g. utf_8_to_euc_jp) for Indian=
>  languages like Hindi, Tamil, etc. seem to be missing.

Want to contribute them?

			regards, tom lane