News for hackers. Stuff that matters.
Re:PostgreSQL Rising by AaronBBrown on Friday July 20, 2012 @04:38PM (#4272787)
1. Yes, applications can set sql_mode themselves at the session level. An admin cannot prevent this. http://dev.mysql.com/doc/refman/5.5/en/server-sql-mode.html
Re:PostgreSQL Rising by einhverfr on Friday July 20, 2012 @09:54PM (#4273698)
So, what good is setting a sensible default as a DBA if the dev guys can override it?

I mean it's fine if you only allow one app to write to your db, but once you have more than one, the fact that the option to ignore invalid data even exists ought to make one very nervous if the data stored is worth anything.

Re:PostgreSQL Rising by AaronBBrown on Saturday July 21, 2012 @08:10AM (#4274616)
A dev can only override it for their session, not at the global level.