Re: Protection from SQL injection - Mailing list pgsql-sql

From Tom Lane
Subject Re: Protection from SQL injection
Date
Msg-id 12890.1209229514@sss.pgh.pa.us
Whole thread Raw
In response to Protection from SQL injection  ("Thomas Mueller" <thomas.tom.mueller@gmail.com>)
List pgsql-sql
"Thomas Mueller" <thomas.tom.mueller@gmail.com> writes:
> SET ALLOW_LITERALS NONE;

I think you missed April Fool's Day...

This is just silly, as it makes life impossibly painful for users
(constants are hardly a useless part of SQL) and it doesn't really
plug any holes.  As an example:
select * from tab where intcol = intcol; delete from tab;

contains no literals and yet the delete is very probably injected.
        regards, tom lane


pgsql-sql by date:

Previous
From: "Thomas Mueller"
Date:
Subject: Protection from SQL injection
Next
From: "Jaime Casanova"
Date:
Subject: Re: Protection from SQL injection