Re: [BUGS] BUG #6485: Primary index key not updated uniformly

2012-02-23 Thread Tom Lane 
Ramanujam  writes:
> On Thu, Feb 23, 2012 at 3:22 PM, Tom Lane  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 (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #6485: Primary index key not updated uniformly

2012-02-22 Thread Ramanujam 
On Thu, Feb 23, 2012 at 3:22 PM, Tom Lane  wrote:
> innomot...@gmail.com 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 (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #6485: Primary index key not updated uniformly

2012-02-22 Thread Tom Lane 
innomot...@gmail.com 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 (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

[BUGS] BUG #6485: Primary index key not updated uniformly

2012-02-22 Thread innomotive 
The following bug has been logged on the website:

Bug reference:  6485
Logged by:  Ramanujam
Email address:  innomot...@gmail.com
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 (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs