Re: Not null constraint in postgre - Mailing list pgsql-novice

Hi Chamath, 

Here is an article explaining the same:::

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

Thanks, Amit

On Mon, Jul 27, 2020 at 11:15 AM Chamath Sajeewa <csgsajeewa@gmail.com> 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