BUG #6485: Primary index key not updated uniformly

[Ramanujam]

The following bug has been logged on the website:

Bug reference:      6485
Logged by:          Ramanujam
Email address:      [hidden email]
PostgreSQL version: 9.0.3
Operating system:   Windows 7 Home Premium
Description:        

Primary key information in pg_attribute table is not updated when a column
name is renamed.

Command used:
ALTER TABLE table_name RENAME COLUMN old_column TO new_column

Entries in pg_attribute still carries old_column.


--
Sent via pgsql-bugs mailing list ([hidden email])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

[Tom Lane-2]

[hidden email] writes:
> Primary key information in pg_attribute table is not updated when a column
> name is renamed.

This is intentional --- we gave up updating index column names awhile
ago.

                        regards, tom lane

--
Sent via pgsql-bugs mailing list ([hidden email])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

[Ramanujam]

On Thu, Feb 23, 2012 at 3:22 PM, Tom Lane <[hidden email]> wrote:
> [hidden email] writes:
>
> This is intentional --- we gave up updating index column names awhile
> ago.

Is pg_constraint a credible place to retrieve primary key information from?

--
Sent via pgsql-bugs mailing list ([hidden email])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

[Tom Lane-2]

Ramanujam <[hidden email]> writes:
> On Thu, Feb 23, 2012 at 3:22 PM, Tom Lane <[hidden email]> wrote:
>> This is intentional --- we gave up updating index column names awhile
>> ago.

> Is pg_constraint a credible place to retrieve primary key information from?

I'd try the information_schema views first.

                        regards, tom lane

--
Sent via pgsql-bugs mailing list ([hidden email])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs