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