BUG #3271: PREPARE/EXCUTE don't work

From: "laurent faillie" <l_faillie(at)yahoo(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3271: PREPARE/EXCUTE don't work
Date: 2007-05-11 15:05:23
Message-ID: 200705111505.l4BF5NE5056281@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 3271
Logged by: laurent faillie
Email address: l_faillie(at)yahoo(dot)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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Heikki Linnakangas 2007-05-11 15:53:36 Re: BUG #3271: PREPARE/EXCUTE don't work
Previous Message Liviu Ionescu 2007-05-11 14:07:57 BUG #3270: limit < 16 optimizer behaviour