And so, it happened. After todays refresh of my Pg, I got:
$ SELECT version(); version ------------------------------------------------------------------------------------------------------------------------ PostgreSQL 9.2devel ON x86_64-unknown-linux-gnu, compiled BY gcc-4.5.real (Ubuntu/Linaro 4.5.2-8ubuntu4) 4.5.2, 64-bit (1 ROW)
Yes. We're in 9.2 development now. Looks like we got another really cool release coming soon.
Thanks a lot to all developers.
And thanks to you Depesz for introducing all the big new features to the wider world. Hopefully we can look forward to more of the same for 9.2. 🙂
Waiting for 9.2 – index-only scans, writable foreign tables, cascading replication, merge/split support, materialised views, not valid constraints, range types, lateral keyword support, json extension, reduced table locks resulting in huge performance boost on multi-core systems… erm… can’t think of other things I anticipate/can realistically be included, but I can probably think of loads I’d want that I doubt would happen for 9.2.
Thanks a LOT to you for explaining all the cool features!
It’s amazing, every new version offers a LOT of new features, and your blog helps to understand this features. Thx!
What a exhaustive news 😛
Also thanks to developers and for you depesz for bringing fresh vawe about pg!
Thanks for all your posts on Postgres Depesz, they really do help the wider masses keep abreast of the latest and greatest in the world of PG.
One feature that I’d like to see for Postgres 9.2, but expect to be shouted down over it, would be equivalents for ‘DESCRIBE ‘ and ‘SHOW CREATE TABLE ‘ that exist in MySQL. All the information is there in the information schema and via the psql client, but these functions make it a lot easier for casually browsing via other tools and even for some programs to quickly pull out bits of information without having to know the structure of the information schema that can be a bit opaque at times.
A SHOW CREATE TABLE, for example, could be used by a program to understand the parts of the schema that it’s interested in, and even to make minor changes, without having to know the very latest information about each version of PG.