Not null constraint in postgre

From: Chamath Sajeewa <csgsajeewa(at)gmail(dot)com>
To: pgsql-novice(at)lists(dot)postgresql(dot)org
Subject: Not null constraint in postgre
Date: 2020-07-27 05:44:47
Message-ID: CACpofejb+KOskR1Dn=fPoi4qAiDgOXP2RKEdtKJK7OFwJ2ebbw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,
There is a column in my table with not null constraint. Default value is
set to 0 for that column. In my query, column value is set to null. When i
try to execute that query in pgsql, it is getting failed due to constraint
violation. Any idea? This is working in oracle.
Thank You!

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Amit S. 2020-07-27 05:49:47 Re: Not null constraint in postgre
Previous Message Tom Lane 2020-07-24 20:08:49 Re: deviation of 12 from 10 or 11