I'm using OIDs for constraint names to guarentee name uniqueness, and
intend to do the same for SERIAL sequences.
The problem with this is that the OID value seems to change with each
run of the regression tests depending on when the last initdb was (in
the case of installcheck) or parallel events in the case of make
check.
There are two solutions that I can see.
One is to make the tests which have data that change in parallel mode
become serial tests (constraints, alter_table and foreign_key).
installcheck will continue to fail if not run immediatly after an
initdb however.
The other is to turn of NOTICE statements for regression tests,
instead displaying only error messages.
For those who are curious, the NOTICE statements in question are
displaying the auto-generated foreign key constraints which table
drops are cascading through. Implicit drop notices (complex type on a
table) have already been removed.
--
Rod