I finally got Bison 1.875 installed on the alpha here, and tried running
regression tests:

============== removing existing temp installation    ==============
============== creating temporary installation        ==============
============== initializing database system           ==============
============== starting postmaster                    ==============
running on port 65432 with pid 2974
============== creating database "regression"         ==============
CREATE DATABASE
ALTER DATABASE
============== dropping regression test user accounts ==============
============== installing PL/pgSQL                    ==============
createlang: language installation failed: ERROR:  stat failed on file
'/home/chriskl/pgsql-temp/src/test/regress/./tmp_check/install//home/chriskl
/local/lib/postgresql/plpgsql': No such file or directory
pg_regress: createlang failed
gmake[2]: Leaving directory `/home/chriskl/pgsql-temp/src/test/regress'
gmake[1]: Leaving directory `/home/chriskl/pgsql-temp/src/test'
bash-2.03$

============================================================

bash-2.03$ more ./src/test/regress/log/initdb.log
Running with noclean mode on. Mistakes will not be cleaned up.
The files belonging to this database system will be owned by user "chriskl".
This user must also own the server process.

The database cluster will be initialized with locale C.

creating directory
/home/chriskl/pgsql-temp/src/test/regress/./tmp_check/data... ok
creating directory
/home/chriskl/pgsql-temp/src/test/regress/./tmp_check/data/base... ok
creating directory
/home/chriskl/pgsql-temp/src/test/regress/./tmp_check/data/global... ok
creating directory
/home/chriskl/pgsql-temp/src/test/regress/./tmp_check/data/pg_xlog... ok
creating directory
/home/chriskl/pgsql-temp/src/test/regress/./tmp_check/data/pg_clog... ok
creating template1 database in
/home/chriskl/pgsql-temp/src/test/regress/./tmp_check/data/base/1... ok
creating configuration files... ok
initializing pg_shadow... ok
enabling unlimited row size for system tables... ok
initializing pg_depend... ok
creating system views... ok
loading pg_description... ok
creating conversions... ok
setting privileges on built-in objects... ok
creating information schema... ok
vacuuming database template1... ok
copying template1 to template0... ok

Success. You can now start the database server using:


/home/chriskl/pgsql-temp/src/test/regress/./tmp_check/install//home/chriskl/
local/bin/postmaster -D
/home/chriskl/pgsql-temp/src/test/regress/./tmp_check/data
or

/home/chriskl/pgsql-temp/src/test/regress/./tmp_check/install//home/chriskl/
local/bin/pg_ctl -D
/home/chriskl/pgsql-temp/src/test/regress/./tmp_check/data -l logfile start

bash-2.03$


Mon, 7 Jul 2003 13:14:13 +0800
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
regressions tests on freebsd/alpha: failure
If I createlang manually:

bash-2.03$ createlang plpgsql template1
ERROR:  Load of file /home/chriskl/local/lib/postgresql/plpgsql.so failed:
dlopen '/home/chriskl/local/lib/postgresql/plpgsql.so' failed.
(/home/chriskl/local/lib/postgresql/plpgsql.so: Undefined symbol
"MakeExprContext")
createlang: language installation failed: ERROR:  Load of file
/home/chriskl/local/lib/postgresql/plpgsql.so failed: dlopen
'/home/chriskl/local/lib/postgresql/plpgsql.so' failed.
(/home/chriskl/local/lib/postgresql/plpgsql.so: Undefined symbol
"MakeExprContext")

Chris

----- Original Message ----- 
From: "Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
To: "Hackers" <pgsql-hackers@postgresql.org>
Sent: Monday, July 07, 2003 1:14 PM
Subject: [HACKERS] regressions tests on freebsd/alpha: failure


> I finally got Bison 1.875 installed on the alpha here, and tried running
> regression tests:
>
> ============== removing existing temp installation    ==============
> ============== creating temporary installation        ==============
> ============== initializing database system           ==============
> ============== starting postmaster                    ==============
> running on port 65432 with pid 2974
> ============== creating database "regression"         ==============
> CREATE DATABASE
> ALTER DATABASE
> ============== dropping regression test user accounts ==============
> ============== installing PL/pgSQL                    ==============
> createlang: language installation failed: ERROR:  stat failed on file
>
'/home/chriskl/pgsql-temp/src/test/regress/./tmp_check/install//home/chriskl
> /local/lib/postgresql/plpgsql': No such file or directory
> pg_regress: createlang failed
> gmake[2]: Leaving directory `/home/chriskl/pgsql-temp/src/test/regress'
> gmake[1]: Leaving directory `/home/chriskl/pgsql-temp/src/test'
> bash-2.03$
>
> ============================================================
>
> bash-2.03$ more ./src/test/regress/log/initdb.log
> Running with noclean mode on. Mistakes will not be cleaned up.
> The files belonging to this database system will be owned by user
"chriskl".
> This user must also own the server process.
>
> The database cluster will be initialized with locale C.
>
> creating directory
> /home/chriskl/pgsql-temp/src/test/regress/./tmp_check/data... ok
> creating directory
> /home/chriskl/pgsql-temp/src/test/regress/./tmp_check/data/base... ok
> creating directory
> /home/chriskl/pgsql-temp/src/test/regress/./tmp_check/data/global... ok
> creating directory
> /home/chriskl/pgsql-temp/src/test/regress/./tmp_check/data/pg_xlog... ok
> creating directory
> /home/chriskl/pgsql-temp/src/test/regress/./tmp_check/data/pg_clog... ok
> creating template1 database in
> /home/chriskl/pgsql-temp/src/test/regress/./tmp_check/data/base/1... ok
> creating configuration files... ok
> initializing pg_shadow... ok
> enabling unlimited row size for system tables... ok
> initializing pg_depend... ok
> creating system views... ok
> loading pg_description... ok
> creating conversions... ok
> setting privileges on built-in objects... ok
> creating information schema... ok
> vacuuming database template1... ok
> copying template1 to template0... ok
>
> Success. You can now start the database server using:
>
>
>
/home/chriskl/pgsql-temp/src/test/regress/./tmp_check/install//home/chriskl/
> local/bin/postmaster -D
> /home/chriskl/pgsql-temp/src/test/regress/./tmp_check/data
> or
>
>
/home/chriskl/pgsql-temp/src/test/regress/./tmp_check/install//home/chriskl/
> local/bin/pg_ctl -D
> /home/chriskl/pgsql-temp/src/test/regress/./tmp_check/data -l logfile
start
>
> bash-2.03$
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>


Mon, 7 Jul 2003 13:19:17 +0800
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Re: regressions tests on freebsd/alpha: failure
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
> If I createlang manually:
> bash-2.03$ createlang plpgsql template1
> ERROR:  Load of file /home/chriskl/local/lib/postgresql/plpgsql.so failed:
> dlopen '/home/chriskl/local/lib/postgresql/plpgsql.so' failed.
> (/home/chriskl/local/lib/postgresql/plpgsql.so: Undefined symbol
> "MakeExprContext")

Sounds to me like an obsolete version of plpgsql.so.  Perhaps your
install failed to overwrite the previous version for some reason?

			regards, tom lane

Mon, 07 Jul 2003 01:49:48 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: regressions tests on freebsd/alpha: failure 
> Sounds to me like an obsolete version of plpgsql.so.  Perhaps your
> install failed to overwrite the previous version for some reason?

Doh!  Just realised I had commented out the building of plpgsql since I had
some non-compilable changes in there :(

Chris


Mon, 7 Jul 2003 15:48:54 +0800
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Re: regressions tests on freebsd/alpha: failure 
> > Sounds to me like an obsolete version of plpgsql.so.  Perhaps your
> > install failed to overwrite the previous version for some reason?
>
> Doh!  Just realised I had commented out the building of plpgsql since I
had
> some non-compilable changes in there :(

And in that case I can confirm that 7.4CVS passes all regression tests on
FreeBSD/Alpha.

Chris


Mon, 7 Jul 2003 16:01:10 +0800
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Re: regressions tests on freebsd/alpha: failure 