Re: preventing ALTER TABLE RENAME from changing view definitions?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "George Pavlov" <gpavlov(at)mynewplace(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: preventing ALTER TABLE RENAME from changing view definitions?
Date: 2007-02-27 02:25:01
Message-ID: 9628.1172543101@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"George Pavlov" <gpavlov(at)mynewplace(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2007-02-27 02:26:23 Re: dropping a master table and all of its partitions?
Previous Message Merlin Moncure 2007-02-27 02:20:49 Re: Most efficient report of number of records in all tables?