Re: BUG #8170: alter user does not accept timestamp output format in certain datestyles and timezones.

chris(dot)travers(at)gmail(dot)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