Amazon Redshift will no longer support the creation of new Python UDFs starting November 1, 2025. If you would like to use Python UDFs, create the UDFs prior to that date. Existing Python UDFs will continue to function as normal. For more information, see the blog post .

error_on_nondeterministic_update

Values (default in bold)

false, true

Description

Specifies whether UPDATE queries with multiple matches per row return an error.

Example

SET error_on_nondeterministic_update TO true;
            
CREATE TABLE t1(x1 int, y1 int);

CREATE TABLE t2(x2 int, y2 int);

INSERT INTO t1 VALUES (1,10), (2,20), (3,30);

INSERT INTO t2 VALUES (2,40), (2,50);

UPDATE t1 SET y1=y2 FROM t2 WHERE x1=x2; 

ERROR: Found multiple matches to update the same tuple.