Received: from megazone.bigpanda.com ([63.150.15.178]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fA1G7BP52466; Thu, 1 Nov 2001 11:07:11 -0500 (EST) (envelope-from sszabo@megazone23.bigpanda.com) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id BB0F5D5D9; Thu, 1 Nov 2001 08:07:07 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id B0BC65BD9; Thu, 1 Nov 2001 08:07:07 -0800 (PST) Date: Thu, 1 Nov 2001 08:07:07 -0800 (PST) From: Stephan Szabo To: "David M. Richter" Cc: , Subject: Re: [SQL] View consistency In-Reply-To: <3BE15A2F.B0CDF610@dkfz.de> Message-ID: <20011101080457.Q22509-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200111/8 X-Sequence-Number: 2533 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.