Hi,
I'm trying to add a timestamp field to an existing table using the following
statement:
ALTER TABLE test ADD COLUMN lunchtime TIMESTAMP NOT NULL DEFAULT
CURRENT_TIME
this fails with the following error:
Cannot add a column with non-constant default
Ok that makes sense - but why can we CREATE a table with a timestamp field
whose default is CURRENT_TIME, but not alter one with that as the default
value? I may be misusing the syntax -
Thanks,
Mark
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
