Talk:What's new in PostgreSQL 9.4
I'm collating a list of blog articles on 9.4 features if it's of any use.
- Yeah, those will help with coming up with use cases. Thanks. I'm only adding content a little at a time though as we've got months to go yet. :)
List of commits mentioning backward incompatibility
commit 13ecb822e8da5668133b706474c25bc908ae370a Author: Bruce Momjian <firstname.lastname@example.org> Date: Sat Apr 19 08:41:51 2014 -0400
libpq: have PQconnectdbParams() and PQpingParams accept "" as default Previously, these functions treated "" optin values as defaults in some ways, but not in others, like when comparing to .pgpass. Also, add documentation to clarify that now "" and NULL use defaults, like PQsetdbLogin() has always done. BACKWARD INCOMPATIBILITY Patch by Adrian Vondendriesch, docs by me Report by Jeff Janes
commit 5f86cbd714c9d43c0fbb43a7b172f77ebf429548 Author: Tom Lane <email@example.com> Date: Wed Apr 16 20:48:51 2014 -0400
Rename EXPLAIN ANALYZE's "total runtime" output to "execution time". Now that EXPLAIN also outputs a "planning time" measurement, the use of "total" here seems rather confusing: it sounds like it might include the planning time which of course it doesn't. Majority opinion was that "execution time" is a better label, so we'll call it that. This should be noted as a backwards incompatibility for tools that examine EXPLAIN ANALYZE output. In passing, I failed to resist the temptation to do a little editing on the materialized-view example affected by this change.
ommit 1420f3a9827a39e5c6c998f6fa35a6fc97903145 Author: Bruce Momjian <firstname.lastname@example.org> Date: Mon Mar 24 14:36:36 2014 -0400
Fix ts_rank_cd() to ignore stripped lexemes Previously, stripped lexemes got a default location and could be considered if mixed with non-stripped lexemes. BACKWARD INCOMPATIBILITY CHANGE
commit d0ee93797d9c06e619b3f382705d99ee195bb573 Author: Bruce Momjian <email@example.com> Date: Sat Feb 1 10:49:17 2014 -0500
arrays: tighten checks for multi-dimensional input Previously an input array string that started with a single-element array dimension would then later accept a multi-dimensional segment. BACKWARD INCOMPATIBILITY
commit c155f654b4f755b4111bd9adb60559fe22526a10 Author: Bruce Momjian <firstname.lastname@example.org> Date: Sat Sep 7 11:44:33 2013 -0400
intarray: return empty zero-dimensional array for an empty array Previously a one-dimensional empty array was returned, but its text representation matched a zero-dimensional array, and there is no way to dump/reload a one-dimensional empty array. BACKWARD INCOMPATIBILITY Per report from elein
commit 457d6cf049c57cabe9b46ea13f26138040a214ec Author: Bruce Momjian <email@example.com> Date: Fri Jun 28 17:27:02 2013 -0400
pg_upgrade: change -u to -U, for consistency Change -u (user) option to -U, for consistency with other tools like pg_dump and psql. Also expand --user to --username, again for consistency. BACKWARD INCOMPATIBILITY