Primary key efficiency - Mailing list pgsql-novice

From Russell Shaw
Subject Primary key efficiency
Date
Msg-id 4013A319.4070604@iprimus.com.au
Whole thread Raw
Responses Re: Primary key efficiency  ("V i s h a l Kashyap @ [Sai Hertz And Control Systems]" <sank89@sancharnet.in>)
Re: Primary key efficiency  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Hi,

Is a long field ok for a primary key, or should i use
a unique integer?:

create table parts (
     manufacturers_code char(40) primary key,
     description char(40),
     man_id int references manufacturers (man_id)
);


pgsql-novice by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: Multiway associations
Next
From: "V i s h a l Kashyap @ [Sai Hertz And Control Systems]"
Date:
Subject: Re: Primary key efficiency