Home > mailing lists

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

From	Amit S.
Subject	Re: Not null constraint in postgre
Date	July 27, 2020 08:49:47
Msg-id	CAC-OOAvv_89Yd1WwUh3dggEWTSmpRetwiRzNLcae0EGCaOvJRQ@mail.gmail.com Whole thread Raw
In response to	Not null constraint in postgre (Chamath Sajeewa <csgsajeewa@gmail.com>)
Responses	Re: Not null constraint in postgre (Chamath Sajeewa <csgsajeewa@gmail.com>)
List	pgsql-novice

Tree view

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

pgsql-novice by date:

From: Chamath Sajeewa
Date: 27 July 2020, 08:44:47
Subject: Not null constraint in postgre

From: Chamath Sajeewa
Date: 27 July 2020, 09:00:47
Subject: Re: Not null constraint in postgre

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

Previous

Next