On Tue, 29 Mar 2011, Roderick A. Anderson wrote:
> A CAST should handle getting the data from the tmp_col back into record.
> The serial was a simple way to get the column incrementally filled.
Actually, CAST does not work from char/varchar to int, bigint, or numeric;
at least, it would not here with 9.0.3 up and running. Shrug.
I created a new column of type bigint, copied values from column record to
the new one, dropped the varchar column, and renamed the bigint column. Then
added a sequence and used that to add values to rows without them.
All's good now.
Thanks to everyone and especially Michael,
Rich