Received: from sss.pgh.pa.us (sss-backup.pgh.pa.us [216.151.103.158]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fA1FmNP35656 for ; Thu, 1 Nov 2001 10:48:23 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id fA1FmAc21917; Thu, 1 Nov 2001 10:48:10 -0500 (EST) To: "David M. Richter" cc: pgsql-sql@postgresql.org Subject: Re: View consistency In-reply-to: <3BE15A2F.B0CDF610@dkfz.de> References: <3BE15A2F.B0CDF610@dkfz.de> Comments: In-reply-to "David M. Richter" message dated "Thu, 01 Nov 2001 15:20:31 +0100" Date: Thu, 01 Nov 2001 10:48:10 -0500 Message-ID: <21914.1004629690@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200111/8 X-Sequence-Number: 5394 "David M. Richter" 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