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.
In response to
pgsql-general by date
|Next:||From: Peter Eisentraut||Date: 2007-01-30 18:46:45|
|Subject: Re: Any Plans for cross database queries on the same server?|
|Previous:||From: Mason Hale||Date: 2007-01-30 17:57:34|
|Subject: Re: Problem loading pg_dump file|