Re: Problem with inheritance

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Alfonso Peniche <alfonso@iteso.mx>
Cc: pgsql-general@postgresql.org
Date: 2001-01-26T16:18:53Z
Lists: 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