On Mon, Nov 21, 2011 at 5:27 PM, Tanmay Patel <tan.patel.may@xxxxxxxxx> wrote: > If I insert a NULL value explicitly into a column declared to be NOT NULL > DEFAULT 0 in postgreSQL 8.4 the column ends up with the default value. If I > do the same in postgreSQL 9.0 I get an error about how I am inserting a null > value into a NOT NULL column. As Tom pointed out you are mistaken. That's a MySQLism. If you want to insert defaults, use the DEFAULT keyword in place of where you're trying to put NULL. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
