Thread: Not null constraint in postgre

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!

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

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!

In order to get the default value to kick in in an insert statement (which I assume you're trying to do), you can either omit that column name from the insert list or set that column value to DEFAULT (no quotes)

Didier

On Mon, 27 Jul 2020 at 07:45, 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!