Re: Problem with inheritance - Mailing list pgsql-general

From Tom Lane
Subject Re: Problem with inheritance
Date
Msg-id 29830.980525933@sss.pgh.pa.us
Whole thread Raw
In response to Problem with inheritance  (Alfonso Peniche <alfonso@iteso.mx>)
List pgsql-general
Alfonso Peniche <alfonso@iteso.mx> writes:
> I have the following inheritance relation:

>           user
>               |
>    ----------
>    |                    |
> student      employee

> If I insert John into table student, how can I insert him afterwards so
> that he is also an employee (this could happen several days later)?

If a student could also be an employee, then your table layout is
fundamentally wrong.

            regards, tom lane

pgsql-general by date:

Previous
From: Alfonso Peniche
Date:
Subject: Problem with inheritance
Next
From: Marc SCHAEFER
Date:
Subject: Re: Problem with inheritance