Re: Converting char to varchar automatically - Mailing list pgsql-general

From Tom Lane
Subject Re: Converting char to varchar automatically
Date
Msg-id 27509.1412637631@sss.pgh.pa.us
Whole thread Raw
In response to Re: Converting char to varchar automatically  (Melvin Davidson <melvin6925@gmail.com>)
Responses Re: Converting char to varchar automatically
List pgsql-general
Melvin Davidson <melvin6925@gmail.com> writes:
> Also, don't forget to test for relkind = 'r'. My bad from before.

In principle you need to ignore attisdropped columns as well.

Thinking about Jim's point about speed: it'd be wise to collapse any
updates for multiple columns in the same table into one ALTER command,
so that you only rewrite the table once, not once per column.

            regards, tom lane


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Converting char to varchar automatically
Next
From: Tim Mickelson
Date:
Subject: Re: Really strange foreign key constraint problem blocking delete