Обсуждение: 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:::
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,
column data type is int4.
Thanks!
On Mon, 27 Jul 2020, 11:19 Amit S., <comeonamit@gmail.com> wrote:
Hi Chamath,Here is an article explaining the same:::Thanks, AmitOn 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
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!
Yes Thank You!!
On Mon, 27 Jul 2020, 11:31 Didier Gasser-Morlay, <didiergm@gmail.com> wrote:
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)DidierOn 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!