additional foreign key test coverage

From: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: additional foreign key test coverage
Date: 2018-12-04 13:15:07
Message-ID: 7ae17c95-0c99-d420-032a-c271f510112b@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

During the development of my recent patch "unused/redundant foreign key
code" [0], I had developed a few additional test cases to increase the
coverage in ri_triggers.c. They are in the attached patches with
explanations. With these, coverage should be pretty complete, except
hard-to-trigger error cases. Interested reviewers can also follow along
on coverage.postgresql.org.

[0]:
https://www.postgresql.org/message-id/flat/2fb8d28c-a4e1-f206-898b-69cd22a393a1(at)2ndquadrant(dot)com/

--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Attachment Content-Type Size
0001-Add-test-case-for-ON-DELETE-NO-ACTION-RESTRICT.patch text/plain 3.5 KB
0002-Increase-test-coverage-in-RI_FKey_pk_upd_check_requi.patch text/plain 3.0 KB
0003-Increase-test-coverage-in-RI_FKey_fk_upd_check_requi.patch text/plain 2.3 KB
0004-Increase-test-coverage-in-RI_Initial_Check.patch text/plain 2.1 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2018-12-04 13:23:20 Re: additional foreign key test coverage
Previous Message didier 2018-12-04 12:18:56 Re: [proposal] Add an option for returning SQLSTATE in psql error message