On Sun, Oct 30, 2011 at 05:08:51PM +0400, ??? scratched on the
wall:
> Default column values conflict with not null option.
By default, yes.
The default default value for all columns is NULL. If you add a
NOT NULL constraint and do not re-define the default value using a
DE
Евгений Земляков wrote:
> Default column values conflict with not null option.
Conflict in what sense? What statement are you executing, and how does the
outcome of running that statement differ from your expectations?
This works for me:
create table t(x integer not null default(42));
--
Igo
Default column values conflict with not null option.
Truly yours, Eugene.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
3 matches
Mail list logo