Re: View consistency - Mailing list pgsql-sql

From Tom Lane
Subject Re: View consistency
Date
Msg-id 21914.1004629690@sss.pgh.pa.us
Whole thread Raw
In response to View consistency  ("David M. Richter" <d.richter@dkfz.de>)
List pgsql-sql
"David M. Richter" <d.richter@dkfz.de> 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, tom lane


pgsql-sql by date:

Previous
From: Arian Prins
Date:
Subject: Re: transposing data for a view
Next
From: "Josh Berkus"
Date:
Subject: Re: transposing data for a view