From 2942023a2a865b64cf1404f369a862aa04dda72b Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Fri, 6 Jan 2006 20:11:31 +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 | 9 +++++++-- 1 file changed, 7 insertions(+), 2 deletions(-) diff --git a/src/backend/rewrite/rewriteManip.c b/src/backend/rewrite/rewriteManip.c index 17c13d6858..a77a1bdd8c 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.80 2003/10/20 20:01:59 tgl Exp $ + * $Header: /cvsroot/pgsql/src/backend/rewrite/rewriteManip.c,v 1.80.2.1 2006/01/06 20:11:31 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" @@ -904,7 +905,11 @@ ResolveNew_mutator(Node *node, ResolveNew_context *context) else { /* Otherwise replace unmatched var with a null */ - return (Node *) makeNullConst(var->vartype); + /* need coerce_to_domain in case of NOT NULL domain constraint */ + return coerce_to_domain((Node *) makeNullConst(var->vartype), + InvalidOid, + var->vartype, + COERCE_IMPLICIT_CAST); } } else -- 2.50.0