Обсуждение: View consistency

Hello!

Im using several views for the Usermanagment of a database.
My question is:

How does postgres keep the views consistent to the according tables( if
the original table has been changed)?

Is there a Rule? and how is the Rule invoked. With ON DELETE UPDATE
INSERT of the original table?
I didnt found any Rule in pg_rules.
There should be a rule, because I cannot imagine another way wich tells
the view that the table has been changed.

The problem is: If updating the view takes too much time after every
little manipulation, I couldnt use views for usermanagement because of
performance problems.
Any hints and facts?

Thanks in advance

David

On Thu, 1 Nov 2001, David M. Richter wrote:

> Hello!
>
> Im using several views for the Usermanagment of a database.
> My question is:
>
> How does postgres keep the views consistent to the according tables( if
> the original table has been changed)?

AFAIK it's a select rule on the view that rewrites into the view
expression.  Nothing keeps it consistent because it's effectively just
a macro for the view expression.