Re: Data type to use for primary key
От
Pierre-Frédéric Caillaud
Тема
Re: Data type to use for primary key
Дата
Msg-id
opshxfh1ibcq72hf@musicbox
Ответ на
Re: Data type to use for primary key (Peter Darley)
Список
Дерево обсуждения
Data type to use for primary key Alexandre Leclerc <alexandre.leclerc@gmail.com>
Re: Data type to use for primary key Josh Berkus <josh@agliodbs.com>
Re: Data type to use for primary key Rod Taylor <pg@rbt.ca>
Re: Data type to use for primary key Josh Berkus <josh@agliodbs.com>
Re: Data type to use for primary key Pierre-Frédéric Caillaud<lists@boutiquenumerique.com>
Re: Data type to use for primary key Alexandre Leclerc <alexandre.leclerc@gmail.com>
Re: Data type to use for primary key Greg Stark <gsstark@mit.edu>
Re: Data type to use for primary key Alexandre Leclerc <alexandre.leclerc@gmail.com>
Re: Data type to use for primary key Tom Lane <tgl@sss.pgh.pa.us>
Re: Data type to use for primary key Greg Stark <gsstark@mit.edu>
Re: Data type to use for primary key Pierre-Frédéric Caillaud<lists@boutiquenumerique.com>
Re: Data type to use for primary key Alexandre Leclerc <alexandre.leclerc@gmail.com>
Re: Data type to use for primary key "Peter Darley" <pdarley@kinesis-cem.com>
Re: Data type to use for primary key Pierre-Frédéric Caillaud<lists@boutiquenumerique.com>
> All, > Well, you should still escape any strings you're getting from a web > page so > you can ensure you're not subject to a SQL insert attack, even if you're > expecting integers. > Thanks, > Peter Darley Well, your framework should do this for you : "integer" specified in your database object class description "%d" appears in in your generated queries (or you put it in your hand written queries) => if the parameter is not an integer, an exception is thrown, then catched, then an error page is displayed... Or, just casting to int should throw an exception... Forms should be validated, but hidden parameters in links are OK imho to display an error page if they are incorrect, after all, if the user edits the get or post parameters, well...
В списке pgsql-performance по дате отправления