chris.trav...@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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs