Sim Zacks <sim@xxxxxxxxxxxxxx> writes: > After the alter table, then I have to update each row with an > update dbmail_messageblks set messageblk=messageblk; > so that it uses the new storage. I wouldn't actually bet on that changing anything at all ... I'd try something like messageblk = messageblk || '' to make completely sure the value gets detoasted. regards, tom lane
