BTW, where can I find a list of type1->type2 pairs that doesn't require full table lock for conversion? ps. Sorry for top posting. On Mon, Oct 6, 2014 at 4:20 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > Melvin Davidson <melvin6925@xxxxxxxxx> 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 > > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general -- Kind regards, Sergey Konoplev PostgreSQL Consultant and DBA http://www.linkedin.com/in/grayhemp +1 (415) 867-9984, +7 (499) 346-7196, +7 (988) 888-1979 gray.ru@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
