changing column from int4 to int8, what happens with indexes?

From: David Teran <david(dot)teran(at)cluster9(dot)com>
To: PgSQL General List <pgsql-general(at)postgresql(dot)org>
Subject: changing column from int4 to int8, what happens with indexes?
Date: 2005-01-04 08:47:30
Message-ID: 44F00930-5E2D-11D9-9812-000A95A6F0DC@cluster9.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

well, i think the answer is simple 'it works' but i am not sure. When i
change the column type from int4 to int8, are the indexes still usable
or do i have to drop the indexes and create them again?

regards, David

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gaurav Anand 2005-01-04 12:35:51 PostgreSql replication with heterogeneous databases!
Previous Message Sim Zacks 2005-01-04 07:50:18 varchar vs text