Re: Apparent anomaly with views and unions - Mailing list pgsql-general

From Greg Stark
Subject Re: Apparent anomaly with views and unions
Date
Msg-id 87sm4155em.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: Apparent anomaly with views and unions  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Apparent anomaly with views and unions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane <tgl@sss.pgh.pa.us> writes:

> I see nothing at all in the spec that justifies the idea of "keep around
> the source text and reinterpret it".  They don't think that way; they
> think in terms of thoroughly-processed "descriptors" stored in the
> system catalogs.

Huh. The thing I find most jarring about this way of thinking is that it means
I can have objects in my database that don't correspond to any source code I
have saved.

Say I want to add an expression to a view, I can't safely take the source as I
created it in the past, add the column, and recreate it. The actual view in
the database may no longer correspond to the create statement I have saved.

I suppose you could say that's no different than the create table statements
which could be obsoleted by a series of alter tables.

--
greg

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Apparent anomaly with views and unions
Next
From: Tom Lane
Date:
Subject: Re: problem with thai language