On Sat, May 1, 2010 at 12:09 PM, Lew <noone@xxxxxxxxxxxxxxxxxxxxxxx> wrote: > Philippe Lang wrote: >> >> I think nobody mentioned Object-Relational mappers. >> If you intend to used one (or think you may be using one in the future), >> using surrogate keys is more straightforward, if not necessary. > > Neither of those claims is even slightly true. Using Hibernate, EclipseLink > or OpenJPA (for Java applications), natural keys are sufficient and far more > straightforward than surrogate keys. right -- to be fair though is quite a bit of (generally bad) software out there that assumes or at least heavily encourages surrogate keys. merlin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general