Re: surrogate key or not?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Kenneth Gonsalves <lawgon(at)thenilgiris(dot)com>, Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: surrogate key or not?
Date: 2004-08-08 22:19:16
Message-ID: 200408081519.16162.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Kenneth,

> but why would anyone want to change the value of an autogenerated serial
row?

But if you're using a real key, it may need to change. The only reason *not*
do do it that way is performance issues with CASCADE.

--
-Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Glaesemann 2004-08-08 23:55:58 Re: UNIQUE constraint
Previous Message Thomas Wegner 2004-08-08 20:39:29 Re: Make a column case insensitive