Bruce Momjian <pgman@candle.pha.pa.us> writes:
> I was doing serial.
Try the parallels a few times, and you *will* see it fail.
Reason: Stephan added a bunch of tests to alter_table.sql that
create/modify/delete tables named pktable and fktable.
Unfortunately, foreign_key.sql uses those same names for its
test tables ... and the parallel tests run these two tests
in parallel. Ooops.
Possible solutions: (a) rename tables in one test or the other,
or (b) use TEMPORARY tables in one test or the other. I kinda
like (b), just to exercise temp tables in some interesting new
ways. Whaddya think?
regards, tom lane