Re: BUG #12752: Regression in ALTER TABLE RENAME COLUMN

From: Gianni Ciolli <gianni(dot)ciolli(at)2ndquadrant(dot)it>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #12752: Regression in ALTER TABLE RENAME COLUMN
Date: 2015-02-09 23:37:15
Message-ID: 20150209233715.GA24454@756b4.gi.lan
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mon, Feb 09, 2015 at 12:49:38PM -0500, Tom Lane wrote:
> We gave up trying to make index column names match the underlying table in
> 9.0; so no currently supported PG release does what you wish, and it's
> unlikely that any future one will either. (This is called out as an
> incompatibility in the 9.0 release notes, FWIW.)

Ah, that makes sense. I had looked up "pg_attribute" in the
documentation, but didn't find anything...

Sorry for the noise.

> > Context information: the bug breaks Londiste, which uses
> > pg_attribute.attname to match columns on the primary key index with the
> > corrisponding columns on the table.
> > I found the bug after a customer reported Londiste issues on a table whose
> > primary key had been renamed.
>
> Sorry, but that's a Londiste bug not a Postgres bug.

Of course; I reported it as context information, meaning that no
motivation is implied.

Best wishes,
Dr. Gianni Ciolli - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gianni(dot)ciolli(at)2ndquadrant(dot)it | www.2ndquadrant.it

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Mark Kirkwood 2015-02-10 01:53:08 Re: BUG #12749: WARNING: unrecognized node type: 701
Previous Message Alvaro Herrera 2015-02-09 17:57:12 Re: BUG #12752: Regression in ALTER TABLE RENAME COLUMN