Postgres Pro
Downloads
Home   >   mailing lists

Re: surrogate key or not? - Mailing list pgsql-sql

From Josh Berkus
Subject Re: surrogate key or not?
Date
Msg-id 200408081519.16162.josh@agliodbs.com
Whole thread Raw
In response to Re: surrogate key or not?  (Kenneth Gonsalves <lawgon@thenilgiris.com>)
List pgsql-sql
Tree view 
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 BerkusAglio Database SolutionsSan Francisco

pgsql-sql by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: UNIQUE constraint
Next
From: Jan Wieck
Date:
Subject: Re: Make a column case insensitive