Re: RfD: more powerful "any" types

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: RfD: more powerful "any" types
Дата
Msg-id b42b73150909141053s261a087cuaabd8b281042f6bd@mail.gmail.com
обсуждение исходный текст
Ответ на Re: RfD: more powerful "any" types  (Pavel Stehule <pavel.stehule@gmail.com>)
Ответы Re: RfD: more powerful "any" types  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-hackers
On Mon, Sep 14, 2009 at 1:42 PM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
>> How is it any worse than what people can already do? Anyone who isn't aware
>> of the dangers of SQL injection has already screwed themselves. You're
>> basically arguing that they would put a variable inside of quotes, but they
>> would never use ||.
>
> simply - people use functions quote_literal or quote_ident.

you still have use of those functions:
execute sprintf('select * from %s', quote_ident($1));

sprintf is no more or less dangerous than || operator.

merlin


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: RfD: more powerful "any" types
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Streaming Replication patch for CommitFest 2009-09