X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id EBCF2528A6 for ; Fri, 27 May 2005 14:25:56 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 71975-02 for ; Fri, 27 May 2005 17:25:54 +0000 (GMT) Received: from web52409.mail.yahoo.com (web52409.mail.yahoo.com [206.190.39.117]) by svr1.postgresql.org (Postfix) with SMTP id 06503528AB for ; Fri, 27 May 2005 14:25:53 -0300 (ADT) Received: (qmail 50467 invoked by uid 60001); 27 May 2005 17:25:52 -0000 Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=BuITw+WHF/LvtjpRIXiliz4W6dutW/reSwvgWEkiPTA+QAkPzhgoJAnH3DLYf7gqS/YEo8c9dulyA2BluUdzB7I4esGUm4kLHmxFrkVtZduVaKigcUCVGAvHqOvsrLlv/DRtcmXIv6LOU0bHmnxONldSEYi0jiJqybrcbLZuqXY= ; Message-ID: <20050527172552.50460.qmail@web52409.mail.yahoo.com> Received: from [12.9.179.126] by web52409.mail.yahoo.com via HTTP; Fri, 27 May 2005 10:25:52 PDT Date: Fri, 27 May 2005 10:25:52 -0700 (PDT) From: Subject: Re: Effectiveness of pg_escape_string at blocking SQL injection To: Ed Finkler , Volkan YAZICI Cc: pgsql-php@postgresql.org In-Reply-To: 6667 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.254 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, NO_REAL_NAME X-Spam-Level: * X-Archive-Number: 200505/40 X-Sequence-Number: 3154 --- Ed Finkler wrote: > Volkan YAZICI wrote: > > [snip] > > > If you think, they're not enough for SQL-Injection > attacks, I'd advice > > you to patch libpq code, not PHP. > > This is very helpful information. My initial > thinking is that this > wouldn't be effective at catching SQL injections, > but I'll need to > bounce this off a few other folks. > > Thanks! do let us all know what you find out. bruno and all... what are bind parameters? how can i avoid building sql from user input when my sql depends on user input? tia... __________________________________ Do you Yahoo!? Yahoo! Small Business - Try our new Resources site http://smallbusiness.yahoo.com/resources/