On Mon, Nov 21, 2011 at 5:27 PM, Tanmay Patel <tan(dot)patel(dot)may(at)gmail(dot)com> 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.