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

From Tom Lane
Subject Re: Apparent anomaly with views and unions
Date
Msg-id 26604.1108277771@sss.pgh.pa.us
Whole thread Raw
In response to Re: Apparent anomaly with views and unions  (Greg Stark <gsstark@mit.edu>)
List pgsql-general
Greg Stark <gsstark@mit.edu> writes:
> 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.

[ shrug... ]  Almost any form of ALTER command gives rise to that
situation; RENAME TABLE being just the most basic.  I can't find
anything compelling in that gripe.  If you want your saved source
code to always describe the database, you mustn't ALTER at all.

There are certainly lots of people who do things just that way,
but they aren't the ones pushing us to add more and more ALTER
functionality ;-)

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: problem with thai language
Next
From:
Date:
Subject: Re: problem with thai language==again