Re: View consistency

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "David M(dot) Richter" <d(dot)richter(at)dkfz(dot)de>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: View consistency
Date: 2001-11-01 15:48:10
Message-ID: 21914.1004629690@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-sql

"David M. Richter" <d(dot)richter(at)dkfz(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Stephan Szabo 2001-11-01 16:07:07 Re: [SQL] View consistency
Previous Message Tom Lane 2001-11-01 15:29:56 Re: CH mirror ?!?!?

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2001-11-01 16:07:07 Re: [SQL] View consistency
Previous Message Jeff Eckermann 2001-11-01 15:47:44 Re: transposing data for a view