pervasiveness of surrogate (also called synthetic) keys
From:
Jim Irrer <irrer(at)umich(dot)edu>
To:
pgsql-general(at)postgresql(dot)org
Cc:
Jim Irrer <irrer(at)umich(dot)edu>
Subject:
pervasiveness of surrogate (also called synthetic) keys
Date:
2011-04-28 17:29:31
Message-ID:
BANLkTikr7ii5CtskEMa53tRtdtwP2hNa_g@mail.gmail.com (view raw or flat )
Thread:
2011-04-28 17:29:31 from Jim Irrer <irrer(at)umich(dot)edu>
2011-04-28 17:44:02 from Andy Colson <andy(at)squeakycode(dot)net>
2011-04-28 17:53:02 from Rob Sargent <robjsargent(at)gmail(dot)com>
2011-04-28 18:31:09 from Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
2011-05-02 09:50:22 from Andres Freund <andres(at)anarazel(dot)de>
2011-04-28 21:00:54 from "David Johnston" <polobo(at)yahoo(dot)com>
2011-04-28 18:20:38 from Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
2011-04-28 18:26:50 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2011-04-28 19:03:43 from Daniele Varrazzo <daniele(dot)varrazzo(at)gmail(dot)com>
2011-04-28 20:39:19 from Merlin Moncure <mmoncure(at)gmail(dot)com>
2011-04-28 21:07:42 from Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
2011-04-29 15:14:07 from Merlin Moncure <mmoncure(at)gmail(dot)com>
2011-05-01 22:12:59 from Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
2011-05-02 15:10:38 from Greg Smith <greg(at)2ndQuadrant(dot)com>
2011-05-02 18:20:59 from Jim Irrer <irrer(at)umich(dot)edu>
2011-05-02 19:21:39 from Merlin Moncure <mmoncure(at)gmail(dot)com>
2011-05-03 00:25:10 from Jeff Davis <pgsql(at)j-davis(dot)com>
2011-05-03 01:43:51 from Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
2011-05-03 01:52:45 from Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
2011-05-03 02:06:38 from Rob Sargent <robjsargent(at)gmail(dot)com>
2011-05-03 02:49:46 from Dann Corbit <DCorbit(at)connx(dot)com>
2011-05-03 02:52:23 from Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
2011-05-03 08:12:17 from Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
2011-05-03 11:25:42 from Rick Genter <rick(dot)genter(at)gmail(dot)com>
2011-05-03 03:07:55 from Greg Smith <greg(at)2ndQuadrant(dot)com>
2011-05-03 03:25:38 from John R Pierce <pierce(at)hogranch(dot)com>
2011-05-03 04:53:30 from Rob Sargent <robjsargent(at)gmail(dot)com>
2011-05-03 05:18:22 from Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
2011-05-03 06:11:15 from Greg Smith <greg(at)2ndquadrant(dot)com>
2011-05-03 04:53:07 from Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
2011-05-03 04:57:29 from Rob Sargent <robjsargent(at)gmail(dot)com>
2011-05-03 05:04:22 from Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
2011-05-03 13:42:02 from Merlin Moncure <mmoncure(at)gmail(dot)com>
2011-05-04 02:03:04 from Greg Smith <greg(at)2ndquadrant(dot)com>
2011-05-04 04:00:06 from David Johnston <polobo(at)yahoo(dot)com>
2011-05-04 07:25:54 from Greg Smith <greg(at)2ndquadrant(dot)com>
2011-05-04 14:32:15 from Merlin Moncure <mmoncure(at)gmail(dot)com>
2011-05-04 19:39:02 from Misa Simic <misa(dot)simic(at)gmail(dot)com>
2011-05-04 20:48:06 from Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
2011-05-03 21:11:36 from Jeff Davis <pgsql(at)j-davis(dot)com>
2011-05-04 02:12:25 from Greg Smith <greg(at)2ndquadrant(dot)com>
2011-05-03 18:51:20 from Jeff Davis <pgsql(at)j-davis(dot)com>
2011-05-03 19:35:28 from Rob Sargent <robjsargent(at)gmail(dot)com>
2011-05-03 21:08:33 from Jeff Davis <pgsql(at)j-davis(dot)com>
2011-05-03 23:36:00 from Rob Sargent <robjsargent(at)gmail(dot)com>
2011-05-02 00:59:52 from Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
2011-05-04 11:14:50 from Misa Simic <misa(dot)simic(at)gmail(dot)com>
2011-05-04 12:34:31 from Merlin Moncure <mmoncure(at)gmail(dot)com>
2011-05-04 12:50:54 from Misa Simic <misa(dot)simic(at)gmail(dot)com>
2011-05-04 13:33:57 from "David Johnston" <polobo(at)yahoo(dot)com>
2011-05-04 13:43:35 from Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
2011-05-04 13:51:51 from Merlin Moncure <mmoncure(at)gmail(dot)com>
Lists:
pgsql-general
A colleague of mine insists that using surrogate keys is the
common practice by an overwhelming margin in relational databases and
that they are used in 99 percent of large installations. I agree that many
situations benefit from them, but are they really as pervasive
as he claims?
Thanks,
- Jim
Responses
pgsql-general by date
Next :From: Andy ColsonDate: 2011-04-28 17:44:02Subject : Re: pervasiveness of surrogate (also called synthetic)
keysPrevious :From : c kDate : 2011-04-28 17:14:09Subject : Re: plpython module import errors
