BUG #7502: ALTER COLUMN TYPE processed even if column type matches

From: tigran(dot)mkrtchyan(at)desy(dot)de
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #7502: ALTER COLUMN TYPE processed even if column type matches
Date: 2012-08-23 14:37:02
Message-ID: E1T4YWs-0004p7-B6@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 7502
Logged by: Tigran Mkrtchyan
Email address: tigran(dot)mkrtchyan(at)desy(dot)de
PostgreSQL version: 9.1.1
Operating system: Linux
Description:

Hi,

we have notice that

ALTER TABLE a_table ALTER COLUMN a_column TYPE varchar(36)

will be processed by postgres even if column types matches to the new one.
Technically, this is not an issue, except on big tables ( ~ 30M entries )
takes some time.

Tigran.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Nupus Cs 2012-08-23 15:26:36
Previous Message Denis Kolesnik 2012-08-23 12:14:02 the bug #7499 is not more a bug, but my missunderstanding (RESOLVED INVALID)