Re: BUG #3271: PREPARE/EXCUTE don't work

laurent faillie wrote:
> 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';

That $1 should be without the quotes, like this:

PREPARE authn_dbd_1 (varchar) AS select mdp from mariage.comptes where
nom = $1

Otherwise the query looks for a user named '$1'.

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com