Change TRUNCATE's method for searching for foreign-key references so that
Tom Lane <tgl@sss.pgh.pa.us>
Change TRUNCATE's method for searching for foreign-key references so that the order in which it visits tables is not dependent on the physical order of pg_constraint entries, and neither are the error messages it gives. This should correct recently-noticed instability in regression tests.
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/catalog/heap.c | modified | +92 −53 |
| src/test/regress/expected/temp.out | modified | +1 −1 |
| src/test/regress/expected/truncate.out | modified | +18 −18 |
| src/test/regress/sql/truncate.sql | modified | +4 −4 |