From 88f2145326ece1bafe2aa1bd0eb2095ba55de1b0 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Fri, 6 Jan 2006 20:11:36 +0000 Subject: [PATCH] Fix failure to apply domain constraints to a NULL constant that's added to an INSERT target list during rule rewriting. Per report from John Supplee. --- src/backend/rewrite/rewriteManip.c | 8 ++++++-- 1 file changed, 6 insertions(+), 2 deletions(-) diff --git a/src/backend/rewrite/rewriteManip.c b/src/backend/rewrite/rewriteManip.c index 46fd85cfca..7af7af81d5 100644 --- a/src/backend/rewrite/rewriteManip.c +++ b/src/backend/rewrite/rewriteManip.c @@ -7,7 +7,7 @@ * * * IDENTIFICATION - * $Header: /cvsroot/pgsql/src/backend/rewrite/rewriteManip.c,v 1.67.2.1 2003/10/20 20:02:30 tgl Exp $ + * $Header: /cvsroot/pgsql/src/backend/rewrite/rewriteManip.c,v 1.67.2.2 2006/01/06 20:11:36 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -18,6 +18,7 @@ #include "optimizer/tlist.h" #include "parser/parsetree.h" #include "parser/parse_clause.h" +#include "parser/parse_coerce.h" #include "rewrite/rewriteManip.h" #include "utils/lsyscache.h" @@ -815,7 +816,10 @@ ResolveNew_mutator(Node *node, ResolveNew_context *context) else { /* Otherwise replace unmatched var with a null */ - return (Node *) makeNullConst(var->vartype); + /* need coerce_type_constraints in case of NOT NULL domain constraint */ + return coerce_type_constraints((Node *) makeNullConst(var->vartype), + var->vartype, + COERCE_IMPLICIT_CAST); } } else -- 2.50.0