Andrew Dunstan <and...@dunslane.net> writes: > It occurred to me after having to change I think 9 files to clean up a > small mess in the jsonb regression tests the other day that we might > usefully expose the inputdir and outputdir to psql as variables when > running pg_regress. Then we might be able to do thing like this, quite > independent of location:
> \set datafile :inputdir/data/mystuff.data > COPY mytable FROM :'datafile'; If we could get rid of the run-time-generated-test-file facility altogether, I could get excited about this; but just getting rid of the COPY special cases isn't enough for that. Looking at convert_sourcefiles_in, it seems like we'd also need solutions for these dynamic substitutions: replace_string(line, "@testtablespace@", testtablespace); replace_string(line, "@libdir@", dlpath); replace_string(line, "@DLSUFFIX@", DLSUFFIX); At least this one seems rather difficult to fix in this fashion: output/create_function_1.source:83:ERROR: could not find function "nosuchsymbol" in file "@libdir@/regress@DLSUFFIX@" (I'm a bit inclined to think that we could dispense with @DLSUFFIX@ altogether; explicit use of the platform's library suffix has been deprecated for at least a decade. But the others are harder.) regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers