Zdenek Kotala wrote:
> It seems that last contrib crypto changes broke buildfarm. You can see
> problem e.g. here:
>
> http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=emperor_moth&dt=2009-08-04%2020:06:01
>
> I don't have time to look on it now. But it should be reproducible
> everywhere.
It's not crypto changes that's the problem -- it's bytea now
being output in hex form (encrypt and decrypt both return bytea):
*** /store/postgres/buildfarm/emperor_moth/HEAD/pgsql.10027/contrib/pgcrypto/expected/3des.out Tue Aug 4 22:06:20
2009
--- /store/postgres/buildfarm/emperor_moth/HEAD/pgsql.10027/contrib/pgcrypto/results/3des.out Tue Aug 4 22:13:42
2009
***************
*** 37,44 **** -- decrypt select decrypt(encrypt('foo', '0123456', '3des'), '0123456', '3des'); decrypt
! ---------
! foo (1 row) -- iv
--- 37,44 ---- -- decrypt select decrypt(encrypt('foo', '0123456', '3des'), '0123456', '3des'); decrypt
! ----------
! \x666f6f (1 row) -- iv
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.