Inherit or Foreign Keys

From: "Ben-Nes Michael" <miki(at)canaan(dot)co(dot)il>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Inherit or Foreign Keys
Date: 2002-04-07 16:03:55
Message-ID: 000701c1de4d$d1eb6e80$aa0f5ac2@canaan.co.il
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All

I want to make a site that's contain articles in multi language. ( The same
article can be seen for example in English, French .... )

I thought of two ways.

1. using Foreign keys.
main tables containing the fields which are not seen like id, settings .....
second table with foreign key to the main ID & field saying the language
name and all the others fields are the translations.

2. using inherit
main tables containing the fields which are not seen like id, settings .....
Second table called as the language name that will inherit the main one with
all the translated fields as title, author ....

Which method looks better for the list ?
Speed is important too :)

--------------------------
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
http://sites.canaan.co.il
--------------------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2002-04-07 18:55:22 Re: retun cursor
Previous Message Frank Joerdens 2002-04-07 14:01:00 Re: Who's using PostgreSQL?