Thread: What's new in PostgreSQL 9.2

What's new in PostgreSQL 9.2

From
Gmail
Date:
Hi,

I've finished writing the "What's new" for 9.2. Here it is:

https://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_9.2

Please, proof-read it, English isn't my native language.

As usual, I had to make choices about what to present here. If your
favorite feature isn't here, please add it, or tell me about it :)


Re: What's new in PostgreSQL 9.2

From
Marc Cousin
Date:
On 28/08/2012 09:58, Gmail wrote:
> Hi,
>
> I've finished writing the "What's new" for 9.2. Here it is:
>
> https://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_9.2
>
> Please, proof-read it, English isn't my native language.
>
> As usual, I had to make choices about what to present here. If your
> favorite feature isn't here, please add it, or tell me about it :)
Wow, sorry about the «gmail» in the smtp headers.  I must have been
really tired when I configured this machine :)




Re: What's new in PostgreSQL 9.2

From
Chris Travers
Date:


On Tue, Aug 28, 2012 at 12:58 AM, Gmail <cousinmarc@gmail.com> wrote:
Hi,

I've finished writing the "What's new" for 9.2. Here it is:

https://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_9.2

Please, proof-read it, English isn't my native language.

As usual, I had to make choices about what to present here. If your
favorite feature isn't here, please add it, or tell me about it :)

A couple points

1)  CHECK ... NO INHERIT should get its own heading.  It isn't really a matter of a NOT VALID check constraint.

2)  I don't know how these are getting ranked but the SECURITY BARRIER bit might do better as a major feature.  It has the potential to be a total game changer in the way multi-tenant applications are developed and viewed.

Best Wishes,
Chris Travers

Re: What's new in PostgreSQL 9.2

From
Marc Cousin
Date:
On 28/08/2012 11:29, Chris Travers wrote:


On Tue, Aug 28, 2012 at 12:58 AM, Gmail <cousinmarc@gmail.com> wrote:
Hi,

I've finished writing the "What's new" for 9.2. Here it is:

https://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_9.2

Please, proof-read it, English isn't my native language.

As usual, I had to make choices about what to present here. If your
favorite feature isn't here, please add it, or tell me about it :)

A couple points

1)  CHECK ... NO INHERIT should get its own heading.  It isn't really a matter of a NOT VALID check constraint.
Agreed. And corrected :)


2)  I don't know how these are getting ranked but the SECURITY BARRIER bit might do better as a major feature.  It has the potential to be a total game changer in the way multi-tenant applications are developed and viewed.

They are ranked by how I felt they can be important for a user at the moment of writing. So the ranking is totally arbitrary.

I agree with your point: for someone developing a multi-tenant application and using views, it is a very important feature. For PostgreSQL users as a whole, I don't know, and I felt it wasn't.

Anyone else having an opinion on this ?

Re: What's new in PostgreSQL 9.2

From
Alvaro Herrera
Date:
Excerpts from Gmail's message of mar ago 28 03:58:40 -0400 2012:
> Hi,
>
> I've finished writing the "What's new" for 9.2. Here it is:
>
> https://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_9.2

The "Reduce ALTER TABLE rewrites" section contains a small mistake -- it
says "x > y" everywhere when it should be x >= y.

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services


Re: What's new in PostgreSQL 9.2

From
Marc Cousin
Date:
On 28/08/2012 16:09, Alvaro Herrera wrote:
> Excerpts from Gmail's message of mar ago 28 03:58:40 -0400 2012:
>> Hi,
>>
>> I've finished writing the "What's new" for 9.2. Here it is:
>>
>> https://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_9.2
> The "Reduce ALTER TABLE rewrites" section contains a small mistake -- it
> says "x > y" everywhere when it should be x >= y.
>
Corrected. Thanks