[HACKERS] pg_regress: referencing shared objects from tests

2008-05-28 Thread Jorgen Austvik - Sun Norway
Hi, we would like to be able to use and ship pg_regress and the PostgreSQL test suite independently of the PostgreSQL build environment, for testing and maybe even as a separate package to be build and shipped with the OS for others to test their setup. Does this sound like a sane and OK

[HACKERS] pg_regress: dbname in PostgreSQL test suite

2008-05-28 Thread Jorgen Austvik - Sun Norway
Hi. pg_regress has a --dbname option (which actually take a list of database names): --dbname=DB use database DB (default \regression\) ... but the PostgreSQL regression test suite does not really support this: [EMAIL PROTECTED]:regress] ggrep -R regression sql/* | grep -v

Re: [HACKERS] pg_regress: referencing shared objects from tests

2008-05-29 Thread Jorgen Austvik - Sun Norway
Tom Lane wrote: Jorgen Austvik - Sun Norway [EMAIL PROTECTED] writes: we would like to be able to use and ship pg_regress and the PostgreSQL test suite independently of the PostgreSQL build environment, for testing and maybe even as a separate package to be build and shipped with the OS

[HACKERS] pg_regress inputdir

2008-07-29 Thread Jorgen Austvik - Sun Norway
Hi, with regards to --inputdir, --srcdir, --outputdir and --schedule, pg_regress does something like this: convert files in srcdir/input, and place them in ./sql convert files in srcdir/output, and place them in ./expected read schedule from schedule for each test in schedule: read test

Re: [HACKERS] pg_regress inputdir

2008-07-30 Thread Jorgen Austvik - Sun Norway
Alvaro Herrera wrote: Jorgen Austvik - Sun Norway wrote: The attached patch makes pg_regress write converted files to inputdir/sql and inputdir/expected, which is one way to make it read and write to the same directory. Tested on Solaris x86 with pgsql make check and standalone. I think

Re: [HACKERS] pg_regress inputdir

2008-07-30 Thread Jorgen Austvik - Sun Norway
Alvaro Herrera wrote: Today, using --inputdir in pg_regress does not work for any other value than something that resolves to cwd, since it will write a file to ./sql, but try to read the same file from inputdir/sql. Maybe I'm missing something, but I don't see any reason why this is a

Re: [HACKERS] pg_regress inputdir

2008-08-04 Thread Jorgen Austvik - Sun Norway
Alvaro Herrera wrote: In my opinion, the need for running tests outside the test dir is not very strong (or we would have heard complaints before), and thus the solution is to remove --inputdir and --outputdir. Attached is a patch that removes --inputdir and --outputdir. I still prefere the

Re: [HACKERS] How to determine if psql returns ZERO to the shell and finished successfully?

2007-11-09 Thread Jorgen Austvik - Sun Norway
Tommy wrote: How exactly can I check to see if psql returns ZERO to the shell? What do I test for? If(Psql.exe)? or is there a variable I can check to see if it has been set? If you are running Delphi on Windows (the MsgBox makes me guess so), take a look here:

[HACKERS] lo_export and lo_import: paths and servers

2007-11-29 Thread Jorgen Austvik - Sun Norway
Hi, The PostgreSQL 8.3 documentation[1] says this about lo_export and lo_import paths and servers: Import: Note that the file is read by the client interface library, not by the server; so it must exist in the client file system and be readable by the client application. Export:

Re: [HACKERS] lo_export and lo_import: paths and servers

2007-11-29 Thread Jorgen Austvik - Sun Norway
Jorgen Austvik - Sun Norway wrote: Problem between keyboard and chair, in doc, libpq, psql or elsewhere? Sorry, the psql documentation is clear on this: \lo_export Note that this is subtly different from the server function lo_export, which acts with the permissions of the user

Re: [HACKERS] Buildfarm member gypsy_moth seems not to like alignment patch

2008-02-28 Thread Jorgen Austvik - Sun Norway
Tom Lane wrote: This is unfortunate and surprising, since that patch was intended to prevent compilers from making unsafe alignment assumptions, but it sure looks like this compiler has instead added a new one. Could you poke into it --- at least get a stack trace from the core dump? Forgot

Re: [HACKERS] Buildfarm member gypsy_moth seems not to like alignment patch

2008-02-28 Thread Jorgen Austvik - Sun Norway
Tom Lane wrote: It looks like gypsy_moth has been failing like this: creating directory /export/home/tmp/pg-test/build-suncc/HEAD/pgsql.21325/src/test/regress/./tmp_check/data ... ok creating subdirectories ... ok selecting default max_connections ... 100 selecting default