Sim Zacks <[EMAIL PROTECTED]> 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general