Postgres Pro
Downloads
Home   >   mailing lists

Not null constraint in postgre - Mailing list pgsql-novice

From Chamath Sajeewa
Subject Not null constraint in postgre
Date
Msg-id CACpofejb+KOskR1Dn=fPoi4qAiDgOXP2RKEdtKJK7OFwJ2ebbw@mail.gmail.com
Whole thread Raw
Responses Re: Not null constraint in postgre  ("Amit S." <comeonamit@gmail.com>)
Re: Not null constraint in postgre  (Didier Gasser-Morlay <didiergm@gmail.com>)
List pgsql-novice
Tree view
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!

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: deviation of 12 from 10 or 11
Next
From: "Amit S."
Date:
Subject: Re: Not null constraint in postgre