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
