| From: | JORGE MALDONADO <jorgemal1960(at)gmail(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | A situation with one parent table and 3 child tables |
| Date: | 2023-10-02 20:57:32 |
| Message-ID: | CAAY=A7_wHBKkKFxuxXc7A+fr3TYGmWS9-hCGghLRDcQAAa_wfQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hi,
I have one parent table (*table_p*) with 3 child tables (*table_ch1*,
*table_ch2
*and *table_ch3*). Each record of the parent table can be associated with 1
and only 1 child table records. This means that:
* Some records of the *table_p* will link to records of *table_ch1*
* Some records of the *table_p* will link to records of *table_ch2*
* Some records of the *table_p* will link to records of *table_ch3*
At first look, this does not make very much sense to me. I thought about
considering 3 parent tables, one for each child table. However, the 3
parent tables would have the same exact structure and I would like to know
if there is a workaround for this issue.
Thanks in advance.
Jorge Maldonado
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gareth Evans | 2023-10-02 21:46:00 | Re: A situation with one parent table and 3 child tables |
| Previous Message | Andreas Joseph Krogh | 2023-09-25 09:58:56 | Sv: DDL in active production database |