Re: Updateable views...

On Tue, 2003-03-04 at 15:26, Eric D Nielsen wrote:
> The one place I haven't been able to use PostGreSQL to experiment is with
> regards to updateable views. I've found a few threads in -general and -hackers
> (including one linked from the ToDo list), but they all seem to die out without
> really reaching any sort of conclusion. I've also seen that in many
> cases it appears possible to use triggers/rules to simulate updateable views,
> but that feels like an inelegant solution to me.

How so? A view is defined by ON SELECT rules; it seems natural, then,
that an updateable view would be defined ON INSERT / ON UPDATE rules.
AFAIK the only deficiency with the status quo is that the system does
not automatically define those insertion rules for you (in the subset of
cases where rules actually *can* be defined: for example, the view can't
include aggregation/grouping, calls to a user-defined function, etc.)

If you'd like to work on getting PostgreSQL to make views updateable
automatically, that would be cool -- AFAIK no one else is currently
working on it.

Cheers,

Neil
--
Neil Conway <neilc(at)samurai(dot)com> || PGP Key ID: DB3C29FC