Re: Bug Report: INSERT ON CONFLICT sometimes does not work with partial index - Mailing list pgsql-bugs

CREATE UNIQUE INDEX IF NOT EXISTS uniq_id_test     ON test USING btree (type, id)     WHERE (type = 'Test');

PREPARE test (text, int, text) AS    INSERT INTO test (type, id)    VALUES ($1, $2)    ON CONFLICT (type, id)    WHERE type = $3 DO    UPDATE    SET id = EXCLUDED.id;

EXECUTE test('Test', 6, 'Test');

The last EXECUTE statement always throws an error:

[42P10] ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification

All of it works fine if we replace $3 parameter with a constant value 'Test' (no errors):

PREPARE test (text, int, text) AS    INSERT INTO test (type, id)    VALUES ($1, $2)    ON CONFLICT (type, id)    WHERE type = 'Test' DO    UPDATE    SET id = EXCLUDED.id;