Re: BUG #8170: alter user does not accept timestamp output format in certain datestyles and timezones. - Mailing list pgsql-bugs

chris.travers@gmail.com writes:
> db=# show timezone;
>    TimeZone
> --------------
>  Asia/Jakarta
> (1 row)

> db=# select now();
>                  now
> -------------------------------------
>  Mon 20 May 11:39:24.273508 2013 WIT
> (1 row)

> db=#  ALTER USER chris with valid until 'Tue 21 May 11:41:14.58554 2013 WIT';
> ERROR:  invalid input syntax for type timestamp with time zone: "Tue 21 May
> 11:41:14.58554 2013 WIT"

> This worked before with different timezones with the same datestyle.  Why is
> this failing?

You need to add WIT to the timezone abbreviation list to allow it to be
used as input:
http://www.postgresql.org/docs/9.2/static/datetime-config-files.html

Or perhaps better, use the ISO datestyle to eliminate the whole issue of
timezone abbreviations.

            regards, tom lane