CREATE TABLE t1 (a int NOT NULL default 42);INSERT INTO t1 values ();SELECT * FROM t1;ALTER TABLE t1 ALTER COLUMN a DROP DEFAULT;--error 1364INSERT INTO t1 values ();INSERT INTO t1 (a) VALUES (11);SELECT * FROM t1 ORDER BY a;DROP TABLE t1;
Loggerhead is a web-based interface for Breezy
Version: 2.0.1