Re: Inherited Table

Peter Harvey <pharvey@codebydesign.com>

From: Peter Harvey <pharvey@codebydesign.com>
To: pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2001-09-06T16:08:47Z
Lists: pgsql-hackers
Hannu Krosing wrote:
> 
> Peter Harvey wrote:
> >
> > Anyone know how inherited tables are shown on an ERD... both the table
> > and the connector (if any)?
> >
> > What I am looking for is how to draw this in the diagram.
> 
> An old S-Designor does it so:
> 

Yes. But pgsql does not support multiple inheritance (from what I can
tell) so the extra symbol along the ref line ("can be"/"must be") seems
silly. I am thinking that I should draw the new table slightly diff in
some way just as is done with Views. However; some purests would freak.
<Hmmm>

Thanks

Peter