Re: [Modeling-users] Re: Implementing inheritance through verticalmapping

[Federico H. <fh...@vi...>]

On Thu, 2003-09-25 at 17:54, Ernesto Revilla wrote:
> For serial, the trick is that the two tables use the same sequence
> generator, so the problem does not appear.

I stand corrected. As a matter of fact, it seems PostgreSQL implements
inheritance in a way that seems completely backwards (and different from
what I thought was happening). Basically, it seems to be doing
horizontal mapping, with selects on the superclass being mapped to a
series of selects on every (grand)*child. One would think that
inheritance could be implemented in a much smarter way from the inside
of the DBMS...

> All this may not be that important if only modeling is used to
> manipulate data as it may take care of it.

That's right.

Thanks for the clarification!

	Fede