Re: Discussion about inheritance

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: msoares(at)masterhoteis(dot)com(dot)br
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Discussion about inheritance
Date: 2003-10-03 14:35:08
Message-ID: 19284.1065191708@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Marcelo Soares" <msoares(at)masterhoteis(dot)com(dot)br> writes:
> To me, this looks not like a bug, because the tuple is not at A phisically.

A lot of people call it a bug because it makes it impossible for them to
use inheritance the way they want to.

> Like I said, this is not a problem for me, but I want to know if someone
> thinks this can be considered a real problem, or if something will be done
> to try to correct (or modify) this operation.

It is likely that it will get changed at some point in the future,
because the consensus seems to be that the other behavior would be more
useful. However, fixing it seems to require building indexes across
multiple tables --- or else a drastic change in the storage
representation of inherited tables --- so it won't happen soon.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruno BAGUETTE 2003-10-03 14:46:16 RE : mod_auth_pgsql 2.0.1 don't close the backend connection
Previous Message Tom Lane 2003-10-03 14:32:20 Re: Type of application that use PostgreSQL