BUG #3271: PREPARE/EXCUTE don't work - Mailing list pgsql-bugs

The following bug has been logged online:

Bug reference:      3271
Logged by:          laurent faillie
Email address:      l_faillie@yahoo.com
PostgreSQL version: 8.2.4
Operating system:   HP-UX 11.11 (v32 bits).
Description:        PREPARE/EXCUTE don't work
Details:

Hi all,

While trying to use Apache 2.2 database authentication, I discovered that I
wasn't able to retrieve users. After some investigation, I found that
PREPARE/EXECUTE are faulty. It can be reproduced in psql as bellow :

www=> PREPARE authn_dbd_1 (varchar) AS select mdp from mariage.comptes where
nom = '$1';
PREPARE
www=> execute authn_dbd_1 ('Test');
 mdp
-----
(0 rows)

www=> select mdp from mariage.comptes where nom = 'Test';
      mdp
---------------
 xxxxxxx
(1 row)

The problem was also in 8.2.3.

Best regards,

Laurent