Re: [GENERAL] using ID as a key

Ed Loehr <eloehr@austin.rr.com>

From: Ed Loehr <eloehr@austin.rr.com>
To: davidb@vectormath.com
Cc: sheila bel <sheilabel@hotmail.com>, pgsql-general@postgresql.org
Date: 2000-02-04T22:39:46Z
Lists: pgsql-general
davidb@vectormath.com wrote:
> 
> Hi Sheila,
> 
> For general database design considerations (not specific to Postgres) I
> disagree with the others on the use of serials and sequences.  These
> things never migrate well from platform to platform, they often break, and
> dealing with them is a nightmare if you ever have to do any bulk data
> copying.
> ID generation ought to be handled programmatically.

I'm ignorant of these problems with serials, but would like to
consider how to avoid them.  Can you give examples of these 3 cases?

Cheers,
Ed Loehr