Hello!
I tried postgresql.v6.4-BETA3 and found some problems especially
with FreeBSD.
The following is my environment:FreeBSD 2.2.7-RELEASEGNU Make version 3.76.1, by Richard Stallman and Roland
McGrath.gccversion 2.7.2.1GNU Bison version 1.25flex version 2.5.4
* makefiles/Makefile.freebsdIt should have "-Bforcearchive" option just like asmakefiles/Makefile.bsd (and it used to
be).Withoutit, I got such errors in test/regress/results/misc.out.
========================================================================
ERROR: Can't find function reverse_name in file
/usr/local/src/postgresql.v6.4-BETA3/pgsql/src/test/regress/input/../regress.so
========================================================================
# And the original Makefile.freebsd does not seem to work# as you intended. As `\' overrides `#', the last 2 lines#
arecommented out together.
* Makefile.shlibFreeBSD is not supported.So no shared library for plpgsql is installed and regressiontest for it
fails.
========================================================================
gmake -C src install
gmake[3]: Entering directory `/usr/local/src/postgresql.v6.4-BETA3/pgsql/src/pl/
plpgsql/src'
/usr/bin/install -c -m 644 /usr/local/pgsql/lib/plpgsql.so
usage: install [-CcDps] [-f flags] [-g group] [-m mode] [-o owner] file1 file2 install [-CcDps] [-f flags] [-g
group][-m mode] [-o owner] file1 ... fileN directory install -d [-g group] [-m mode] [-o owner]
directory...
gmake[3]: *** [install] Error 64
========================================================================
And no shared libraries for libecpg, libpq++ and libpq.aare made and installed.
* pg_dumpallPg_dumpall command outputs "create database" statement such as:
========================================================================
create database with encoding='EUC_JP' DBNAME;
========================================================================But it should be:
========================================================================
create database DBNAME with encoding='EUC_JP';
========================================================================
Regards
--
ASCII CORPORATION
Technical Center
SHIOZAKI Takehiko
<takehi-s@ascii.co.jp>