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.