Re: changing column from int4 to int8, what happens with indexes?
От | Michael Fuhr |
---|---|
Тема | Re: changing column from int4 to int8, what happens with indexes? |
Дата | |
Msg-id | 20050104160850.GA91596@winnie.fuhr.org обсуждение исходный текст |
Ответ на | changing column from int4 to int8, what happens with indexes? (David Teran <david.teran@cluster9.com>) |
Ответы |
Re: changing column from int4 to int8, what happens with indexes?
|
Список | pgsql-general |
On Tue, Jan 04, 2005 at 09:47:30AM +0100, David Teran wrote: > 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? What happened when you tried it? You can use EXPLAIN or EXPLAIN ANALYZE to see if the planner will use an index. If you changed the type with 8.0's ALTER TABLE ALTER COLUMN TYPE then see the documentation for ALTER TABLE: ALTER COLUMN TYPE This form changes the type of a column of a table. Indexes and simple table constraints involving the column will be automatically converted to use the new column type by reparsing the originally supplied expression. If you did something else, then what was it? -- Michael Fuhr http://www.fuhr.org/~mfuhr/
В списке pgsql-general по дате отправления: