Materializing a view by hand - Mailing list pgsql-general

I have a view which is very slow to computer, but doesn't change often.

I'd like to materialize it. I thought I'd do a simple poor man's materialize by:

1) ALTER VIEW myview RENAME to _myview
2) SELECT * INTO myview FROM _myview

The only problem is that all my other views, which are dependent on
myview, automatically rename to _myview.  That would normally be very
helpful but is exactly the opposite of what I want!

Is there a work around?

 I'm running Postgres 8.3 - upgrading is a possibility but difficult.