PostgreSQL 9.0 released

Posted Sep 20, 2010 18:01 UTC (Mon) by dskoll (subscriber, #1630)
Parent article: PostgreSQL 9.0 released

I've been running 9.0-rc1 for a while and I can't wait to upgrade our production boxes to 9.0.

Someone wrote Not a single change I could disagree with. I found one incredibly minor change that caused us a bit of trouble:

By default, multicolumn indexes are now named after all their columns; and index expression columns are now named based on their expressions (Tom Lane)

This means that databases created in 8.x may have different index names than those created in 9.0. It means our schema-updating code has to handle both cases. Nevertheless, this is a good change in the long run and worth the small bit of pain needed to modify our schema-updating code.

PostgreSQL 9.0 released

Posted Sep 20, 2010 18:59 UTC (Mon) by flewellyn (subscriber, #5047) [Link] (1 responses)

That only applies if the name argument is omitted. Your schema-updating code can still assign names as it sees fit.

PostgreSQL 9.0 released

Posted Sep 20, 2010 19:48 UTC (Mon) by dskoll (subscriber, #1630) [Link]

Well, the point is that in the past, we omitted names for convenience. Now when it comes time to drop indexes that were created in the past, we need to try both versions of the name because we can't be sure which one really exists.

As I said: Not really a big deal. Just something to watch out for.