Drop table if exits temptable cascade ;
Create temp table temptable ...
Create temp view tempview as select . from temptable...
Select .. from tempview ...
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
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2007-11-28 23:11:27|
|Subject: Re: was enhancement of temp tables in plpgsql supposed to apply to temp views as well? appears it did not. |
|Previous:||From: paulo||Date: 2007-11-28 17:52:29|
|Subject: BUG #3787: configure: error: readline library not found|