pgcryto failures on freebsd/alpha

Hi Marko,

Just testing pgcrypto on freebsd/alpha. I get some warnings:

gcc -pipe -O -Wall -Wmissing-prototypes -Wmissing-declarations -fpic -DPIC
-DRAND_SILLY -I. -I. -I../../src/include -c -
o internal.o internal.c
internal.c: In function `rj_encrypt':
internal.c:314: warning: cast from pointer to integer of different size
internal.c: In function `rj_decrypt':
internal.c:342: warning: cast from pointer to integer of different size
internal.c: In function `bf_encrypt':
internal.c:429: warning: cast from pointer to integer of different size
internal.c: In function `bf_decrypt':
internal.c:453: warning: cast from pointer to integer of different size

And I can't do regression:

gmake -C ../../src/test/regress pg_regress
gmake[1]: Entering directory
`/home/chriskl/postgresql-7.2b4/src/test/regress'
gmake[1]: `pg_regress' is up to date.
gmake[1]: Leaving directory
`/home/chriskl/postgresql-7.2b4/src/test/regress'
../../src/test/regress/pg_regress init md5 sha1 hmac-md5 hmac-sha1 blowfish
rijndael crypt-des crypt-md5 crypt-blowfish cryp
t-xdes
(using postmaster on Unix socket, default port)
============== dropping database "regression" ==============
ERROR: DROP DATABASE: database "regression" does not exist
ERROR: DROP DATABASE: database "regression" does not exist
dropdb: database removal failed
============== creating database "regression" ==============
CREATE DATABASE
============== dropping regression test user accounts ==============
ERROR: DROP GROUP: group "regressgroup1" does not exist
============== installing PL/pgSQL ==============
============== running regression test queries ==============
test init ... ERROR: stat failed on file
'$libdir/pgcrypto': No such file or directory
ERROR: stat failed on file '$libdir/pgcrypto': No such file or directory
ERROR: stat failed on file '$libdir/pgcrypto': No such file or directory
ERROR: stat failed on file '$libdir/pgcrypto': No such file or directory
ERROR: stat failed on file '$libdir/pgcrypto': No such file or directory
ERROR: stat failed on file '$libdir/pgcrypto': No such file or directory
ERROR: stat failed on file '$libdir/pgcrypto': No such file or directory
ERROR: stat failed on file '$libdir/pgcrypto': No such file or directory
ERROR: stat failed on file '$libdir/pgcrypto': No such file or directory
ERROR: stat failed on file '$libdir/pgcrypto': No such file or directory
ERROR: stat failed on file '$libdir/pgcrypto': No such file or directory
ERROR: stat failed on file '$libdir/pgcrypto': No such file or directory
FAILED
test md5 ... ERROR: Function 'digest(unknown, unknown)'
does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'digest(unknown, unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'digest(unknown, unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'digest(unknown, unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'digest(unknown, unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'digest(unknown, unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'digest(unknown, unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
FAILED
test sha1 ... ERROR: Function 'digest(unknown, unknown)'
does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'digest(unknown, unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'digest(unknown, unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'digest(unknown, unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'digest(unknown, unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'digest(unknown, unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'digest(unknown, unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
FAILED
test hmac-md5 ... ERROR: Function 'hmac(unknown, bytea,
unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'hmac(unknown, unknown, unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'hmac(bytea, bytea, unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'hmac(bytea, bytea, unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'hmac(unknown, bytea, unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'hmac(unknown, bytea, unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'hmac(unknown, bytea, unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
FAILED
test hmac-sha1 ... ERROR: Function 'hmac(unknown, bytea,
unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'hmac(unknown, unknown, unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'hmac(bytea, bytea, unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'hmac(bytea, bytea, unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'hmac(unknown, bytea, unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'hmac(unknown, bytea, unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'hmac(unknown, bytea, unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
FAILED
test blowfish ... ERROR: Function 'encrypt(bytea, bytea,
unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'encrypt(bytea, bytea, unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'encrypt(bytea, bytea, unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'encrypt(bytea, bytea, unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'encrypt(bytea, bytea, unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'encrypt(bytea, bytea, unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'encrypt(bytea, bytea, unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'encrypt(bytea, bytea, unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'encrypt(bytea, bytea, unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'encrypt(bytea, bytea, unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'encrypt(bytea, bytea, unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
FAILED
test rijndael ... ERROR: Function 'encrypt(bytea, bytea,
unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'encrypt(bytea, bytea, unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'encrypt(bytea, bytea, unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'encrypt(bytea, bytea, unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'encrypt(bytea, bytea, unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'encrypt(bytea, bytea, unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'encrypt(bytea, bytea, unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
FAILED
test crypt-des ... ERROR: Function 'crypt(unknown, unknown)'
does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'crypt(unknown, unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'gen_salt(unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'crypt(text, text)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'crypt(text, text)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
FAILED
test crypt-md5 ... ERROR: Function 'crypt(unknown, unknown)'
does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'crypt(unknown, unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'gen_salt(unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'crypt(text, text)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'crypt(text, text)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
FAILED
test crypt-blowfish ... ERROR: Function 'crypt(unknown, unknown)'
does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'crypt(unknown, unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'gen_salt(unknown, int4)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'crypt(text, text)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'crypt(text, text)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
FAILED
test crypt-xdes ... ERROR: Function 'crypt(unknown, unknown)'
does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'crypt(unknown, unknown)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'gen_salt(unknown, int4)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'crypt(text, text)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
ERROR: Function 'crypt(text, text)' does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
FAILED

========================
11 of 11 tests failed.
========================

The differences that caused some tests to fail can be viewed in the
file `./regression.diffs'. A copy of the test summary that you see
above is saved in the file `./regression.out'.