| From: | Nelio Alves Pereira Filho <nelio(at)ifx(dot)com(dot)br> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Inheritance and Foreign Keys |
| Date: | 2001-01-04 20:17:08 |
| Message-ID: | 3A54DA44.A6BFA694@ifx.com.br |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Here's my situation: I have the following relation
table A -----<>------ table B
1:N
I created the two tables, and a foreign key from A into B. Now I want to
create other tables that inherit from B, but I want that the relation
exists for all of them. For that, I created another table, C, that had
just one field and inherited from B. No errors showed up, but it didn't
complain when I inserted some data into C without the corresponding one
in A!!
Is it possible to do what I intended?
Thanks
--
Nelio Alves Pereira Filho
IFX Networks - www.ifx.com.br
+55 11 3365-5863
nelio(at)ifx(dot)com(dot)br
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave VanAuken | 2001-01-04 22:04:50 | running pgsql 7 under Jail'ed virtual machine on FreeBSD 4.2 |
| Previous Message | Soma Interesting | 2001-01-04 19:39:56 | Test for existence of Table |