IntegrityError with Booleand Fields and Postgresql

Question

I have this simple Blog model:

class Blog(models.Model):

    title = models.CharField(_('title'), max_length=60, blank=True, null=True)
    body = models.TextField(_('body'))
    user = models.ForeignKey(User)  
    is_public = models.BooleanField(_('is public'), default = True)

When I insert a blog in admin interface, I get this error:

IntegrityError at /admin/blogs/blog/add/

null value in column "is_public" violates not-null constraint

Why ???

Answer 1

Hmm. Odd quirk. Can't say why it is happening because the default should mean it's always set, but this should fix it, if you apply the relevant schema change/migration

is_public = models.BooleanField(_('is public'), default=True, null=True)