Re: head contrib is broken (crypto)

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.