was enhancement of temp tables in plpgsql supposed to apply to temp views as well? appears it did not.

["chris wood" <chrisj(dot)wood(at)sympatico(dot)ca>]

Plpgsql procedure:

 

BEGIN

Drop table if exits temptable cascade ;

 

Create temp table temptable …..

 

Create temp view tempview as select … from temptable…..

 

Select …. from tempview  …..

END

 

The first time I run this after I create the procedure it works perfectly.

The second time I get notices that the drop is cascading to the view (this was expected and OK)

But then the select fails

ERROR: could not open relation …. No such file or directory