Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

There are certain cases I run into where PostgreSQL doesn't support parameterization. For example, utility statements in PostgreSQL have no associated plan, so they have no parameters. If you want to run a utility statement (like CREATE ROLE or DROP ROLE) you have to do so via string concatenation. This is true even in stored procedures which gives you the uncomfortable possibility of SQL injection occurring inside a stored procedure already running with elevated permissions.


Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: