Re: NULL value vs. DEFAULT value.

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: byrnejb(at)harte-lyne(dot)ca
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: NULL value vs. DEFAULT value.
Date: 2011-03-08 15:13:30
Message-ID: 4D76479A.30607@iol.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 08/03/2011 14:54, James B. Byrne wrote:
> My question is: Why am I getting a NULL exception? Should I only
> specify DEFAULT and drop the NOT NULL constraint?

Good question. Are you trying to insert an explicit NULL?

Can you show us your INSERT statement?

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Igor Neyman 2011-03-08 15:42:11 Re: Why count(*) doest use index?
Previous Message Thom Brown 2011-03-08 15:10:32 Re: NULL value vs. DEFAULT value.