Re: [SQL] View consistency

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 rew

Re: [SQL] View consistency

"David M. Richter" <[EMAIL PROTECTED]> writes: > How does postgres keep the views consistent to the according tables( if > the original table has been changed)? It doesn't have to; views are not materialized in Postgres. A view is just a rewrite rule, or macro. regards,

[SQL] 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 d