Unique field key or several fks ?

From: Katarn <katarn(at)amnet(dot)co(dot)cr>
To: pgsql-sql(at)postgresql(dot)org
Subject: Unique field key or several fks ?
Date: 2004-01-12 05:18:36
Message-ID: 40022E2C.6000701@amnet.co.cr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

I would like to know opinions about which approach is better:

Having a table with a field that works as a unique key, or having
several fks that work as a combined key ( all the fks fields )?

Thanks in advance,

K.

Browse pgsql-sql by date

  From Date Subject
Next Message katarn 2004-01-12 05:51:17 Unique key field or serverl fks ?
Previous Message Robert Creager 2004-01-12 04:04:54 Problem with NOT IN portion of query.