BUG #6363: pgp_sym_encrypt() broken between 8.4 and 9.1

From: dean(dot)w(dot)schulze(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6363: pgp_sym_encrypt() broken between 8.4 and 9.1
Date: 2011-12-28 23:21:08
Message-ID: E1Rg2o0-0005Pk-L8@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 6363
Logged by: Dean Schulze
Email address: dean(dot)w(dot)schulze(at)gmail(dot)com
PostgreSQL version: 9.1.1
Operating system: Windows 7 Pro 64-bit
Description:

The following worked in 8.4, but fails in 9.1. (pgpcrypto is installed.)

In 9.1 it looks like it doesn't recognize strings.

insert into credentials values('demo', pgp_sym_encrypt('password',
'longpassword'));

ERROR: function pgp_sym_encrypt(unknown, unknown) does not exist
LINE 1: insert into credentials values('demo', pgp_sym_encrypt('pass...
^
HINT: No function matches the given name and argument types. You might need
to add explicit type casts.

********** Error **********

ERROR: function pgp_sym_encrypt(unknown, unknown) does not exist
SQL state: 42883
Hint: No function matches the given name and argument types. You might need
to add explicit type casts.
Character: 40

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message basilbourque 2011-12-28 23:58:53 BUG #6364: The URL for the page listing user groups is unresponsive.
Previous Message lsq 2011-12-28 20:58:50 Re: simultaneous autovacuum and postmaster crash