Re: Time zone "GST" not recognized.

2020-01-24 Thread Adrian Klaver
On 1/24/20 9:57 AM, nikhil raj wrote: Hi Adrian, Thanks for the quick response. Please can you help me over here So Postgres is not supporting GST ( Gulf Standard Time) time zone .  As if we have a entries of few things with timestamp with time zone  from application end. example :- In 2 co

Re: Time zone "GST" not recognized.

2020-01-24 Thread Tom Lane
nikhil raj writes: > Please can you help me over here So Postgres is not supporting GST ( Gulf > Standard Time) time zone . As if we have a entries of few things with > timestamp with time zone from application end. You could set up a private timezone abbreviation configuration. https://www.po

Re: Time zone "GST" not recognized.

2020-01-24 Thread nikhil raj
Hi Adrian, Thanks for the quick response. Please can you help me over here So Postgres is not supporting GST ( Gulf Standard Time) time zone . As if we have a entries of few things with timestamp with time zone from application end. example :- In 2 column we are entering these details but whe

Re: Time zone "GST" not recognized.

2020-01-24 Thread Adrian Klaver
On 1/24/20 9:19 AM, Adrian Klaver wrote: On 1/24/20 8:59 AM, nikhil raj wrote: Hi ALL, Required help with the time zone. i am getting error on the GST time line. is tht a bug or postgres doesn't support the GST time zone. select CURRENT_TIMESTAMP AT TIME ZONE 'GST' ERROR: time zone "GST" no

Re: Time zone "GST" not recognized.

2020-01-24 Thread Adrian Klaver
On 1/24/20 8:59 AM, nikhil raj wrote: Hi ALL, Required help with the time zone. i am getting error on the GST time line. is tht a bug or postgres doesn't support the GST time zone. select CURRENT_TIMESTAMP AT TIME ZONE 'GST' ERROR: time zone "GST" not recognized SQL state: 22023 Try GMT:

Re: Time zone "GST" not recognized.

2020-01-24 Thread Tom Lane
nikhil raj writes: > Required help with the time zone. i am getting error on the GST time line. > is tht a bug or postgres doesn't support the GST time zone. There is no such time zone abbreviation according to the IANA time zone database [1], which is what we rely on. re