Re: PostgreSQL 9.0

On 30 Jan 2007 12:15:17 -0800, Karen Hill <karen_hill22(at)yahoo(dot)com> wrote:
> On Jan 29, 11:06 pm, qne(dot)(dot)(dot)(at)gmail(dot)com ("Dawid Kuroczko") wrote:
> > * updatable views [ or am I missing something? ] -- it seems to me
> > they were close to be completed, but I don't remember if they were
> > completed and committed or not.
>
> PostgreSQL has updatable views via the rules system. I use updatable
> views all the time in postgres.

That is not a point really. This todo is not about implementing rule
system which PostgreSQL already has.

It's about implementing infrastructure to set up updatable views automatically,
as the standard dictates. And this is a feaure PostgreSQL lacks. If you
want updatable views you have to issue couple of CREATE RULEs apart
from CREATE VIEW. The point is that you could create updatable views
with sole CREATE VIEW command.

Another example is table partitioning which PostgreSQL has and doesn't
have. You can set up table partitioning with clever set of triggers and
table inheritance, but it lacks explicit DDLs to do so.

Regards,
Dawid