| From: | Bo Lorentsen <bl(at)netgroup(dot)dk> |
|---|---|
| To: | Ben-Nes Michael <miki(at)canaan(dot)co(dot)il> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Inherit or Foreign Keys |
| Date: | 2002-04-08 07:05:48 |
| Message-ID: | 1018249548.2741.31.camel@netgroup |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sun, 2002-04-07 at 18:03, Ben-Nes Michael wrote:
> 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.
Please go for this solution.
>
> 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 ....
The OO model i PG is not ready for real use, yet, So, please don't use
it for production.
/BL
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Samuele Brignoli | 2002-04-08 07:16:11 | I: Migrating a very large db |
| Previous Message | impala | 2002-04-08 06:06:54 | Auto Insert date/time |