lalbin@fhcrc.org writes:
> I have run across a situation where we are changing schema and table names
> that a view references. The view is still viewable with a select statement
> but if you try and execute the view definition contained within the
> pg_catalog.pg_views, then it fails.
This appears to be a variant of the what-alias-to-use-after-a-rename
problem that we were discussing last winter:
http://archives.postgresql.org/message-id/29791.1327718297@sss.pgh.pa.us
That thread kinda died off after coming to the conclusion that there
isn't a simple, obviously correct solution. The code's current behavior
is definitely wrong in the face of renames, but I don't want to change
it in a way that just moves the failure cases elsewhere (which is what
would happen for any of the proposals made in the thread :-().
regards, tom lane