Marc Evans <Marc@xxxxxxxxxxxxxxxxxxx> writes: > ... I have a table with about 15000 records in it, which I > would like to add a new column to. The alter command shows success. > However, testing inserts reveals that the data for the new column is never > stored. What do you mean by that exactly? The example you showed seems to be doing just what it's supposed to. regards, tom lane