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