Hi everyone,
I have a problem with adding a column to an existing table. I want to add
a column named modified which is of datatype TIMESTAMP and has a DEFAULT
CURRENT_TIMESTAMP as it's initial value. I cannot do this with ALTER
TABLE, it tells me to user ALTER TABLE SET DEFAULT instead but I cannot
figure out the syntax with the help of the manuals.
My ALTER TABLE looked like this:
alter table decks add column modified timestamp default current_timestamp;
and the error I get is this:
ERROR: Adding columns with defaults is not implemented. Add the column, then use ALTER TABLE SET DEFAULT.
Thanks in advance,
Archie