Re: alter column type
| От | John R Pierce |
|---|---|
| Тема | Re: alter column type |
| Дата | |
| Msg-id | 5571FFD6.7090401@hogranch.com обсуждение исходный текст |
| Ответ на | Re: alter column type (Casey Deccio <casey@deccio.net>) |
| Ответы |
Re: alter column type
|
| Список | pgsql-general |
On 6/5/2015 11:46 AM, Casey Deccio wrote:
On Fri, Jun 5, 2015 at 2:36 PM, Michael Nolan <htfoot@gmail.com> wrote:Probably too late for this time, but in the past when I've needed to redefine the type for a column, I've made a dump, edited the dump file to change the type and then renamed the table and reloaded it. That's usually several orders of magnitude faster.Actually, not too late. My first ALTER is still running, and I still have four more to go. Sigh. I had thought of this but wasn't sure how it might compare. Thanks for the data point :)
if all 5 alters' were to the same table, you should have combined them into one alter statement.
-- john r pierce, recycling bits in santa cruz
В списке pgsql-general по дате отправления: