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