Re: [BUGS] BUG #8170: alter user does not accept timestamp output format in certain datestyles and timezones.
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
Re: [BUGS] BUG #8167: false EINVAL -22 for opening a file
I've tested Tom Lane's fix, on 9.2.4 on my Mac, and it seems to have solved the problem. Thanks! https://github.com/postgres/postgres/commit/6563fb2b45146852601e63828308fe04fb03b9e9
[BUGS] BUG #8171: Log messages lacking enough details
The following bug has been logged on the website: Bug reference: 8171 Logged by: Trond Endrestøl Email address: trond.endres...@ximalas.info PostgreSQL version: 9.2.4 Operating system: FreeBSD/amd64 9.1-STABLE r250805 Description: The log message: LOG: could not bind IPv6 socket: Can't assign requested address should be augmented to reveal the attempted address, thus making the lives of us poor db admins a lot easier. Likewise for any similar IPv4 related log messages. In fact all kinds of log/warning/error messages should be to the point and include all(!) relevant details and not just a vague description of what happened. The above log message was due to the file /etc/hosts containing the two lines: localhost fe80::1 localhost fe80:2::1 Changing these two lines to: localhost-6ll fe80::1 localhost-6ll fe80:2::1 made PostgreSQL much happier. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs