Postgres Pro
Downloads
Home   >   mailing lists

Re: preventing ALTER TABLE RENAME from changing view definitions? - Mailing list pgsql-general

From Tom Lane
Subject Re: preventing ALTER TABLE RENAME from changing view definitions?
Date
Msg-id 9628.1172543101@sss.pgh.pa.us
Whole thread Raw
In response to preventing ALTER TABLE RENAME from changing view definitions?  ("George Pavlov" <gpavlov@mynewplace.com>)
List pgsql-general
Tree view 
"George Pavlov" <gpavlov@mynewplace.com> writes:
> Currently "ALTER TABLE ... RENAME TO ..." results in all views that
> refer to the table to be rewritten with the new table name.

They are not "rewritten".  Views refer to tables by OID, and are
therefore entirely insensitive to RENAME operations.  This is not
something we're likely to change.

            regards, tom lane

pgsql-general by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: Most efficient report of number of records in all tables?
Next
From: Alvaro Herrera
Date:
Subject: Re: dropping a master table and all of its partitions?