From: | Jeff Davis <pgsql(at)j-davis(dot)com> |
---|---|
To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
Cc: | 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-30 18:42:29 |
Message-ID: | 1170182549.22436.15.camel@dogma.v10.wvs |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, 2007-01-30 at 02:35 -0800, Joshua D. Drake wrote:
> > Something different than rules?
> > (http://www.postgresql.org/docs/8.2/interactive/rules.html) (They exist for a
> > while, I've just linked the latest released docs...)
> >
> Quite. Rules are not updateable views. Rules are a hacked up way to
> create an updateable view.
I wouldn't go that far. Rules can do things that updatable views can't
do. Sometimes a view can't be updatable because an update to that view
would be ambiguous (as far as the system knows), but you can still use
the well-defined rules system to *tell* the system what you want an
update to mean.
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.
Regards,
Jeff Davis
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2007-01-30 18:46:45 | Re: Any Plans for cross database queries on the same server? |
Previous Message | Mason Hale | 2007-01-30 17:57:34 | Re: Problem loading pg_dump file |