Re: Avoiding surrogate keys

From: Lew <noone(at)lwsc(dot)ehost-services(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Avoiding surrogate keys
Date: 2010-05-01 16:09:00
Message-ID: hrhjms$nbv$1@news.albasani.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

--
Lew

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2010-05-01 16:16:03 Re: Native DB replication for PG
Previous Message Tom Lane 2010-05-01 15:27:46 Re: Native DB replication for PG