Re: Avoiding surrogate keys - Mailing list pgsql-general

From Lew
Subject Re: Avoiding surrogate keys
Date
Msg-id hrhjms$nbv$1@news.albasani.net
Whole thread Raw
In response to Re: Avoiding surrogate keys  (Philippe Lang <philippe.lang@attiksystem.ch>)
Responses Re: Avoiding surrogate keys  (Merlin Moncure <mmoncure@gmail.com>)
List 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

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Native DB replication for PG
Next
From: Thomas Løcke
Date:
Subject: PostgreSQL vs. Microsoft SQL server