"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes: > Just wondering if someone could give me an indication as to how to create a > new regression test, for the ADD UNIQUE stuff I did?
It's not hard. Make a file in src/test/regress/sql containing test queries, and one in src/test/regress/sql/expected containing the expected output (which is just the *actual* output, after you've checked it over). Add the test name to src/test/regress/serial_schedule and src/test/regress/parallel_schedule. If your test needs to cater for platform-dependent source or output then things are a little harder, but I don't see why an ADD UNIQUE test would need that. Actually, I don't see why you wouldn't just add some more test queries to src/test/regress/sql/alter_table.sql and corresponding output to src/test/regress/expected/alter_table.out. But if you really want a separate test file, the two _schedule files are the places that need to know about it. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])