Postgres Pro
Downloads
Home   >   mailing lists

changing column from int4 to int8, what happens with indexes? - Mailing list pgsql-general

From David Teran
Subject changing column from int4 to int8, what happens with indexes?
Date
Msg-id 44F00930-5E2D-11D9-9812-000A95A6F0DC@cluster9.com
Whole thread Raw
Responses Re: changing column from int4 to int8, what happens with indexes?
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: hundreds of millions row dBs
Next
From: "Gaurav Anand"
Date:
Subject: PostgreSql replication with heterogeneous databases!