Bret Stern wrote on 08.09.2012 22:18:
A better place for validation is in the front-end, before adding/attempting to add data to the db (my opinion). Nice to see there are always other ways though.
I beg to differ: every validation that can be enforced by declarative constraints *should* be checked there. As a wise man once said: your application won't be the last one to use the data and it won't be the only one. And most of the data that is of any interest lives a lot longer than the application(s). Nowaday it's not uncommon that multiple applications read and write to the same database and in that case you simply cannot rely on all of them to validate the data. Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
