| 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 |