Re: Problem with inheritance

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alfonso Peniche <alfonso(at)iteso(dot)mx>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Problem with inheritance
Date: 2001-01-26 16:18:53
Message-ID: 29830.980525933@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Alfonso Peniche <alfonso(at)iteso(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marc SCHAEFER 2001-01-26 16:32:17 Re: Problem with inheritance
Previous Message Tom Lane 2001-01-26 16:15:45 Re: beta3 Solaris 7 (SPARC) port report