Re: PostgreSQL 9.0

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jeff Davis <pgsql(at)j-davis(dot)com>
Cc: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, Jorge Godoy <jgodoy(at)gmail(dot)com>, Dawid Kuroczko <qnex42(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: PostgreSQL 9.0
Date: 2007-01-31 06:02:13
Message-ID: 16370.1170223333@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jeff Davis <pgsql(at)j-davis(dot)com> writes:
> Updatable views provide a subset of the functionality of rules, but they
> do it automatically without much effort on the part of the DBA. That's
> great, but it won't replace rules.

Exactly --- but there is also a place for a low-effort, "do the right
thing" feature, which is pretty much what the SQL spec's concept of
updatable views is.

There's also some question about whether our current definition of rules
can even support a non-surprising implementation of an updatable view.
The issue of multiple evaluation of what might be volatile expressions
keeps coming up...

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2007-01-31 06:03:25 Re: Any Plans for cross database queries on the same server?
Previous Message Paul Lambert 2007-01-31 05:46:41 Re: Any Plans for cross database queries on the same server?