Re: [SQL] View consistency - Mailing list pgsql-admin

From Stephan Szabo
Subject Re: [SQL] View consistency
Date
Msg-id 20011101080457.Q22509-100000@megazone23.bigpanda.com
Whole thread Raw
In response to View consistency  ("David M. Richter" <d.richter@dkfz.de>)
List pgsql-admin
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.


pgsql-admin by date:

Previous
From: "Philippe Rochat"
Date:
Subject: CH mirror ?!?!?
Next
From: GB Clark II
Date:
Subject: Re: FreeBSD upgrade causes performance degredation