inheritance and foreign keys
От | Jo |
---|---|
Тема | inheritance and foreign keys |
Дата | |
Msg-id | 1005388376.813718@seven.kulnet.kuleuven.ac.be обсуждение исходный текст |
Список | pgsql-general |
I was reading about inheritance and it occurred to me that this was what my DB design needed. I had been creating mini-tables that perfectly applied as child tables to other tables. So I set out to implement it. Of course I am using primary and foreign keys and I thought it was odd that it was not possible to REFERENCE my FKs to my PKs. So I started to give my child tables their own PKs back. (I had taken them out, convinced I was not going to need them anymore. The PK was supposed to be in the parent table) Great, this approach seemed to work. Now I'm starting to populate my tables and I stumble over yet a new problem. When I create an entry in a child table and I go over to look to the parent table, it is there. When I try to reference this entry in the parent table from yet another table, it comes to tell me it doesn't exist. I don't want to have to reference it in the child table. That would defeat the entire purpose of having chosen this approach. I wonder why this database is called Object Relational if this concept is noet able to work properly with PK and FK relations. And I mean: out of the box. I found ways to make my own triggers, but I don't have time to extend the functionality of the DBS. Abandoning this approach again and going back to using PostgreSQL strictly as a RDBMS. Jo
В списке pgsql-general по дате отправления: