Postgres Pro
Downloads
Home   >   mailing lists

Unique key field or serverl fks ? - Mailing list pgsql-sql

From katarn
Subject Unique key field or serverl fks ?
Date
Msg-id 400235D5.1050501@racsa.co.cr
Whole thread Raw
Responses Re: Unique key field or serverl fks ?
List pgsql-sql
Tree view 
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.

pgsql-sql by date:

Previous
From: Robert Creager
Date:
Subject: Problem with NOT IN portion of query.
Next
From: Tomasz Myrta
Date:
Subject: Re: Problem with NOT IN portion of query.