public inbox for [email protected]  

help / color / mirror / Atom feed

From: Amit S. <[email protected]>
To: Chamath Sajeewa <[email protected]>
Cc: [email protected]
Subject: Re: Not null constraint in postgre
Date: Mon, 27 Jul 2020 11:19:47 +0530
Message-ID: <CAC-OOAvv_89Yd1WwUh3dggEWTSmpRetwiRzNLcae0EGCaOvJRQ@mail.gmail.com> (raw)
In-Reply-To: <CACpofejb+KOskR1Dn=fPoi4qAiDgOXP2RKEdtKJK7OFwJ2ebbw@mail.gmail.com>
References: <CACpofejb+KOskR1Dn=fPoi4qAiDgOXP2RKEdtKJK7OFwJ2ebbw@mail.gmail.com>

Hi Chamath,

Here is an article explaining the same:::

https://www.enterprisedb.com/postgres-tutorials/how-null-and-empty-strings-are-treated-postgresql-vs...

Thanks, Amit

On Mon, Jul 27, 2020 at 11:15 AM Chamath Sajeewa <[email protected]>
wrote:

> 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!
>


-- 

Amit Sharma

view thread (5+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Not null constraint in postgre
  In-Reply-To: <CAC-OOAvv_89Yd1WwUh3dggEWTSmpRetwiRzNLcae0EGCaOvJRQ@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox