Skip site navigation (1) Skip section navigation (2)

Re: partial indexes not used on parameterized queries?

From: Dirk Lutzebäck <lutzeb(at)aeccom(dot)com>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org, Sven Geisler <sgeisler(at)aeccom(dot)com>
Subject: Re: partial indexes not used on parameterized queries?
Date: 2006-07-10 13:28:13
Message-ID: 44B255ED.40004@aeccom.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Ok, we checked our client code to eliminate this problem. Thanks for the 
doc patch.

Regards,

Dirk

Simon Riggs wrote:
> On Mon, 2006-07-10 at 13:35 +0200, Dirk Lutzebäck wrote:
>
>   
>> In any case I would see this as a security problem because you cannot
>> control sql code injection easily (as with using DBD::Pg) if you have
>> to pass parameters in the SQL string to use partial indexes.
>>     
>
> That's not what I said. I see no security problem as a result of this
> behaviour.
>
>   

-- 
/This email and any files transmitted with it are confidential and 
intended solely for the use of the individual or entity to whom they are 
addressed. If you are not the intended recipient, you should not copy 
it, re-transmit it, use it or disclose its contents, but should return 
it to the sender immediately and delete your copy from your system. 
Thank you for your cooperation./

*Dirk Lutzebäck* <lutzeb(at)aeccom(dot)com> Tel +49.30.5362.1635 Fax .1638
CTO AEC/communications GmbH <http://www.aeccom.com>, Berlin, Germany

In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2006-07-10 22:12:55
Subject: Re: ALTER TYPE ... USING(NULL) / NOT NULL violation
Previous:From: Simon RiggsDate: 2006-07-10 12:29:37
Subject: Re: partial indexes not used on parameterized queries?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group