Re: BUG #7553: Un-executable view definitions in pg_catalog.pg_views in versions 8.3.x-9.2.0

lalbin(at)fhcrc(dot)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