Commit682b128

committed

Fix NOT NULL option for plpgsql variables (doesn't look like it

could ever have worked...)

1 parent0ad5e43 commit682b128Copy full SHA for 682b128

File tree

-7

lines changed

-7

lines changed

Lines changed: 9 additions & 7 deletions

Original file line number	Diff line number	Diff line change
`@@ -3,7 +3,7 @@`
`3`	`3`	`* procedural language`
`4`	`4`	`*`
`5`	`5`	`* IDENTIFICATION`
`6`		`- * $Header: /cvsroot/pgsql/src/pl/plpgsql/src/pl_exec.c,v 1.34 2001/01/04 02:38:02 tgl Exp $`
	`6`	`+ * $Header: /cvsroot/pgsql/src/pl/plpgsql/src/pl_exec.c,v 1.35 2001/01/06 01:43:01 tgl Exp $`
`7`	`7`	`*`
`8`	`8`	`* This software is copyrighted by Jan Wieck - Hamburg.`
`9`	`9`	`*`
`@@ -2210,6 +2210,7 @@ exec_assign_value(PLpgSQL_execstate * estate,`
`2210`	`2210`	`intnatts;`
`2211`	`2211`	`Datum*values;`
`2212`	`2212`	`char*nulls;`
	`2213`	`+Datumnewvalue;`
`2213`	`2214`	`boolattisnull;`
`2214`	`2215`	`Oidatttype;`
`2215`	`2216`	`int32atttypmod;`
`@@ -2225,15 +2226,16 @@ exec_assign_value(PLpgSQL_execstate * estate,`
`2225`	`2226`	`* ----------`
`2226`	`2227`	`*/`
`2227`	`2228`	`var= (PLpgSQL_var*)target;`
`2228`		`-var->value=exec_cast_value(value,valtype,var->datatype->typoid,`
`2229`		`-&(var->datatype->typinput),`
`2230`		`-var->datatype->typelem,`
`2231`		`-var->datatype->atttypmod,`
`2232`		`-isNull);`
	`2229`	`+newvalue=exec_cast_value(value,valtype,var->datatype->typoid,`
	`2230`	`+&(var->datatype->typinput),`
	`2231`	`+var->datatype->typelem,`
	`2232`	`+var->datatype->atttypmod,`
	`2233`	`+isNull);`
`2233`	`2234`
`2234`		`-if (isNull&&var->notnull)`
	`2235`	`+if (*isNull&&var->notnull)`
`2235`	`2236`	`elog(ERROR,"NULL assignment to variable '%s' declared NOT NULL",var->refname);`
`2236`	`2237`
	`2238`	`+var->value=newvalue;`
`2237`	`2239`	`var->isnull=*isNull;`
`2238`	`2240`	`break;`
`2239`	`2241`

Comments

(0)