To inherit or not to inherit
От | glenn |
---|---|
Тема | To inherit or not to inherit |
Дата | |
Msg-id | 1064465421.6149.20.camel@odin.valhalla обсуждение исходный текст |
Список | pgsql-general |
I have a design question re postgres's feature of inheritance, and I need to determine if I should use this feature in this instance. I have a heirachy of tables and some associated functions that are used to cost (and store the costing) of manufacturing jobs. The resulting 'job' may then become a job that is tracked through a work flow, or included in a 'price list' or 'catalog'. Either way any given 'job' becomes a child of another header table - simply by adding 2 fields, 1 with the 'typeofjob' which determines which table will be used to find and control the job, the other the key of that header table. However it seems that this is what 'inheritance' as it exists in postgres is for - correct? It seems I can achieve the same thing with out using the 2 extra fields? I've avoided using inheritance before, but am wondering what considerations do I need to take on board to make this decision. Will it make this easier or more difficult? Thanks for any tips Glenn
В списке pgsql-general по дате отправления: