Re: IS it a good practice to use SERIAL as Primary Key?

From: Scott Ribe <scott_ribe(at)killerbytes(dot)com>
To: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: IS it a good practice to use SERIAL as Primary Key?
Date: 2006-11-27 21:03:25
Message-ID: C190A0AD.5C28D%scott_ribe@killerbytes.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> OK, let's use a synthetic key on the sales master table. In fact,
> *both* companies have a synthetic key on their sales master tables.
>
> OMG, conflicting/overlapping synthetic keys!!!!!

Which are not exposed in any UI and therefore easier to change?

Heck, I'd use UUIDs everywhere if it weren't such a pain in the neck to type
them into queries.

--
Scott Ribe
scott_ribe(at)killerbytes(dot)com
http://www.killerbytes.com/
(303) 722-0567 voice

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John McCawley 2006-11-27 21:04:01 Re: IS it a good practice to use SERIAL as Primary Key?
Previous Message Scott Ribe 2006-11-27 21:00:35 Re: IS it a good practice to use SERIAL as Primary Key?